Joe, It appears you were right about queries just needing to be optimized. Some of the same queries that ran fine in SQL 2000 were unbelieveable...
This server was just freshly loaded with only the OS and SQL Server on it. SQL Server is the only load on it. We do not have a trace from before the...
We ran profiler and some of the queries are not the most efficient, but they are not anything that should max out the processor. The entire database...
We upgraded a database server from Windows 2003 Standard with SQL Server 2000 to Windows 2003 Enterprise with SQL Server 2005. We also went from the...
Thanks Joe. That looks like a great configuration with a lot of spindles and the price seems much more reasonable than I would have thought. I am...
Satya, Thanks, but I'm not sure you understood my concern. I'm concerned more with the speed than with the size. The first option has the log...
Satya, I understand "bulk load to a staging table", but am not sure what you mean by "compute your calculations for further import to main tables"....
One more RAID 5 vs. RAID 1+0 question... My server has 8 drive bays, and I need to configure these to be optimized for a high IO database. Is it...
I assumed those things were being done as pert of the database maintenance plan that is scheduled, but now that you mention it... I don't see those...
You should probably set the amount of memory sql server can use... leaving enough for the OS to do it's thing. otherwise the OS will have to compete...
Yes, we've been working to optimize the sql and have cleaned it up quite a bit. We've gotten to the point where the amount of time put into...
I know I've heard the more spindles, the better. But how should they be configured is the question. Since 32 drives divided by 8 channels is 4 drives...
Our sql server performance has deteriorated as the size of the database grew. I know there is already a hard drive bottleneck (which I'm working on),...
My database server has 8 bays in it. Current configuration is 5 x 72GB 15k drives as Raid 5 and 2 x 34GB 10k drives as raid 1. 1 bay has a hot spare....
SQL Server 2005 Standard which supports unlimited memory. Louder+Harder+Faster >= Better
We have Windows Server 2003 Standard box running SQL Server 2000 that we are in the process of upgrading to SQL Server 2005 Standard. It has been...
Separate names with a comma.
