2
votes
2answers
348 views

Windows Server 2003 r2 vs 2008 r2 - Performance for SQL Server [closed]

First off, I'm not a sys admin, just a programmer frustrated by poor server performance… We’re currently running a VM (I believe the host is Win Server 2008) on a newer E5-2650 CPU, 24 GB RAM, at ...
0
votes
3answers
566 views

Increasing vCPUs for Server 2003?

I have a VM running Server 2003 and SQL Server 2008 on VMware ESXi. Can I safely assume this configuration can cope with a change to the number of vCPUs? Are there better solutions to address the ...
1
vote
1answer
237 views

Is there a negative impact to using SQL Server with a lower compatibility level

We have SQL Server 2008 R2 which we are using for a database with a compatibility level set as 2005 (90). We will by upgrading it to 2008 at some point, but in the meantime I would like to know if ...
1
vote
2answers
3k views

Does splitting out Data, Logs, and TempDB matter using a SAN with SQL 2008

I'm not a server admin. So be gentle. But I was just at a conference and in one of the training classes the Instructor explained some SQL DBA best practices. One of which was to separate out ...
1
vote
1answer
116 views

Is replication less resource intensive than high frequency reads?

I am beginning the development of a new web application which needs to be designed to scale from the word go. I am looking into database replication and the concept of master/slave replication (or ...
-1
votes
1answer
133 views

Page Fault of 1,000,000 in 64 GB RAM Server [closed]

I have a 64 bit Machine that runs SQL Server. It has 64 GB RAM. It is giving around 1,000,000 Page Faults per second. Is it OK or it is giving too many Page Faults? if the number is hign the what ...
1
vote
2answers
843 views

Ridiculously slow queries on Microsoft SQL Server 2008 R2

I'm getting really slow queries in MS SQL Server 2008 R2 on my dev machine. This problem has been plaguing me for about a month. Other developers don't have the same problem, but we all run the same ...
0
votes
2answers
134 views

New server: use for SQL Server or Windows (Web)? [closed]

I picked up a new Dell R410 2.8 Ghz 12M cache 32 GB Ram RAID-1/RAID-1 for a good year-end deal. It was purchased mainly to replace my Dell PowerEdge 2850 which is my main WEB server. I run Windows ...
0
votes
3answers
61 views

SQL Server Sizing

I need to create a design to meeting the following requirements for a coupon system coupons to be issued every 6 weeks each issuance will give approx 90m coupon instances coupon instance record can ...
-2
votes
3answers
173 views

True or False: a table with large records (rows) and lots of fields (columns) will take longer to return a SQL query? [closed]

True or False: a table with large records (rows) due to lots of fields (columns) will take longer to return a SQL query? That is, if I have a SELECT ... WHERE...query in SQL that operates on a table ...
0
votes
4answers
651 views

SQL Server 2008 R2 Express and VMware

We have used SQL Server Express - various versions without issue. However we have an install on a VMware machine and there are severe performance issues. I have contacted VMware and Microsoft - ...
0
votes
1answer
95 views

Server Configuration

Recently we have got problems with performance in SQL Server 2008 Enterprise. One idea to solve it is to scale up, i.e. improve hardware of the server. SQL Server 2008 has 2 instances that are ...
2
votes
3answers
1k views

Performance differences between SQL Server 2008 Standard and Enterprise

Aside from features like partioning, indexed views and parallel indexing, are there any actual performance differences between the Standard and Enterprise editions of SQL Server 2008? Also, is the ...
0
votes
1answer
62 views

Store data on File Server or SQL database

We have a solution which includes storage of PDF documents. Currently we have 50,000 documents that are 0.6 MB each (all documents same size) We currently store these documents in varbinary(max) ...
0
votes
1answer
48 views

SQL2008R2 Partitioning query

We have a complex query that returns results in 45 secs when run from the 01-05-11 to the 31-05-11, but when it is extended to the 01-06-11 it runs indefinately... THe tables are partition by ...
2
votes
1answer
184 views

What's the best use of 4 nics for Hyper-V?

I'm running several Dell R710's, each of which is outfitted with 4 x Broadcom BCM5709C nics. Two of these R710's are running Hyper-V and a third is running SQL Server 2008, each running Windows ...
0
votes
2answers
262 views

MVC2 Application Performance on Windows Server 2008 R2 with IIS7.5

I originally posted this on StackOverflow but I feel as though the problem lies with the hardware / OS configuration. I'm hoping that someone here has had a similar experience and can offer some ...
7
votes
1answer
326 views

sys.dm_exec_query_stats interaction with recompilation

We use sys.dm_exec_query_stats to track down slow queries and queries that are IO offenders. This works great, we get a lot of very insightful stats. It is clear this is not as accurate as running a ...
0
votes
5answers
813 views

My dedicated server keeps getting very slow that it fails to load the application

I have an application running on Windows Server 2008, running IIS 7.5, SQL Server 2008, 4GB RAM from brinkster. The problem is, every couple of days I get the same 10,000 calls that the system is ...
2
votes
1answer
163 views

SQL Server 2008 Partitioned Table and Parallelism

My company is moving to SQL Server 2008 R2. We have a table with tons of archive data. Majority of the queries that uses this table employs DateTime value in the where statement. For example: ...
1
vote
2answers
353 views

How do large blobs affect SQL delete performance, and how can I mitigate the impact?

I'm currently experiencing a strange issue that my understanding of SQL Server doesn't quite mesh with. We use SQL as our file storage for our internal storage service, and our database has about half ...
0
votes
0answers
124 views

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a ...
2
votes
3answers
185 views

Where to start fixing an IO Bottle neck in SQL Server?

I recently came across an interesting article that went over using IO statistics to identify the causes of performance issues. After examining my statistics i came to the determination that i had a ...
0
votes
1answer
367 views

SQL Server - VMWare install - Utilize more RAM

We have a SQL server machine - It’s a VMWare image (running on ESXi hardware etc..) It has windows 2008 x64 standard The SQL install is SQL 2008 standard The virtual machine has 12gb of RAM, and 4 ...
1
vote
2answers
287 views

SQL Server Full Text Search resource consumption

When SQL Server builds a fulltext index computer resources are consumed (IO/Memory/CPU) Similarly when you perform full text searches, resources are consumed. How can I get a gauge over a 24 hour ...
1
vote
1answer
132 views

SQL Server 2008 Web VS SQL Server 2008 Enterprise

I wrote an application a few months ago, and was hosting it out of our offices on a workstation with an Intel Core 2 Quad Q8200 @ 2.33GHz, 8 GB RAM, Windows Server 2008 Enterprise and SQL Server 2008 ...
0
votes
2answers
634 views

How much memory should I have to run Windows 2008 Server and SQL Server 2008 Web?

I need to improve performance because currently my website is too slow. I'm currently running SQL Server 2008 Express on a dual-core server with 2 GB of memory. My app seems to be CPU-bound ...
1
vote
1answer
329 views

SQL Server EXPRESS 2008 R2 crippling performance issues

My company has recently requested that all our developers gain knowledge and experience using SQL server database’s (as opposed to sitting in VS all day long). We are all using SQL Server EXPRESS 2008 ...
0
votes
4answers
2k views

Performance Monitor w/ SQL Server - how many counters is too many?

I'm doing some performance analysis using the built-in Windows Performance Monitor, both on general hardware and SQL Server. I've been reading a lot about which performance counters to use; in ...
1
vote
2answers
472 views

Will solid state drive improve performance of a database?

I have a Microsoft SQL Server 2008 database which contains approximately 3 GB of data. The server has 4 GB of RAM. The database is used both for reading and for writing data (lots of changes). The ...
1
vote
1answer
103 views

How to get similar performance with hyper-v r2 and native server with sql 2008 server?

We currently have a physical server with 4 physical cpu. Which will be the best VM configuration for SQL Server? If I configure my native server I will have much better performance because I will ...
2
votes
3answers
4k views

What would be the optimal disk config for SQL Server 2008 R2?

We have a new Dell R710 server that came with the following storage configuration: 8 x 146GB SAS 10k 6Gbps disks 1 x Perc H700 Integrated Controller (2 x 4 disks - 2 ports each supporting 4 disks) ...
0
votes
1answer
394 views

NT to unix password sync service?

I am developing using VSTS 2008 + C# + ASP.Net on Windows Server 2003 x86 to develop asp.net application with SQL Server 2008 Express. I find sometimes my system is very slow (not very responsive) ...
1
vote
3answers
612 views

Server Performance Issue - Server 2008, SQL 2008 and Hyper-V [screenshots]

Im getting nasty performance on my server. It happens radmonly while accessing a website, but more often, right on the first time I load it. The server/webapp are still in dev, so I'm the only one ...
5
votes
5answers
9k views

Would the database compatibility level affect performance?

We just migrated our Microsoft SQL Server from 2005 enterprise to 2008 standard on the same specification hardware. The databases were backed up and then restored to a clean sql 2008 install. The ...
0
votes
3answers
1k views

SQL Server 2008 faster in Windows XP than in Windows 2003 Server R2

The Windows XP configuration is a generic computer with a Pentium D 2.8GHz, 1GB of RAM, with Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Build 3790: Service Pack 2) The Windows Server 2003R2 is ...