1
vote
4answers
1k views

High CXPACKET wait type in SQL Server even with MAXDOP = 1

I have always had a very high CXPACKET wait type, and I've been told that it stems from parallel processing, and I should keep MAXIMUM DEGREE OF PARALLELISM = (NÂș Processors / 4), or 1 in my case. ...
2
votes
3answers
852 views

How can I speed up SQL Server queries on Amazon EC2?

Our SQL queries sometimes take too long. We have a Windows Server 2003/SQL Server 2005 setup. We have already created indexes everywhere that's possible. Can we get quicker disks? Any ideas from ...
0
votes
1answer
492 views

SQL Server blocking queries

My normal running SQL Server 2005 SP3 servers started experiencing random blocking issues over the past month. Each time it happens I run my blocking script to see whats blocking what (see code block ...
1
vote
3answers
74 views

Is there an advantage to allocating much more space than needed in Sql 2005?

Folks, I'm migrating 2 databases from a cluttered hard drive to a new one I purchased specifically to host these two databases. The databases are roughly equal in size and projected to grow equally. ...
0
votes
1answer
85 views

Reccomendation for tuning 100's of SQL Databases

I'm running several SQL servers, each running a few hundred multi-gig databases for customers. They are all setup homogeneously as far as the schemas are concerned, however customer usages of the ...
0
votes
1answer
322 views

Should I partition my main table with 2 millions rows?

I am a developer and would need some DBA-advices. We are starting to get performance problem with a MSSQL2005 database. The visible effects of the incidents is mainly CPU-hog on the server but ...
1
vote
2answers
1k views

SQL Server 2005 standard filegroups / files for performance on SAN

I submitted this to stack overflow (here) but realised it should really be on serverfault. so apologies for the incorrect and duplicate posting: Ok so I've just been on a SQL Server course and we ...
1
vote
2answers
155 views

What kind of database server should I use for a 500k stored procedure calls per day database?

I have a database that gets about 500,000 stored procedure calls a day in addition to other stuff. It's running too slow for us and we're going to upgrade it when we get around to it. I'm looking at ...