Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
mshdean
Starting Member
1 Post |
 Posted - 2008-12-10 : 08:47:06
|
| Please note that I am not a SQL expert but hope someone may be able to help me understand why we should be seeing poorer SQL performance after a disk upgrade.This is a SQL 2005 environment. Most SQL tasks are performing faster as expected and all independent tests (such as IOMeter) show a significant performance improvement from the new disk subsystem. There are however a number of tasks where performance has decreased. Interestingly these tasks do not generate any significant IO and are also bound to a single thread using 90%-100% of CPU utilization suggesting disk is not the bottleneck. We are therefore expecting these tests to run at the same performance as the old disk subsystem but it is fact slower.I would be interested to hear of any ideas why SQL should be behaving like this and also any suggestions on which metrics we could monitor to prove this.Many thanks in anticipation of your input. Mark |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-12-10 : 10:03:22
|
| Which task is running slow? Maybe you want to Update stats,Rebuild index ? |
 |
|
|
|
|
|
Unexpected results from faster disk