October 5, 2010 at 10:40 am
I know this forum is for SQL 2005 performance issues, but I have a server hopelessly stuck on 2000 and have run into the following:
3 separate arrays:
OS on 1st array
Logs on 2nd array
Data and tempdb on 3rd array
No problems performance wise until 1 week ago. Ran profiler and saw very high duration times. Ran perfmon and saw disk pressure on the Data drive. Have done a number of things including reindexing (dropping and re-creating), updating all statistics, physical defrag of drives. Today when I run a profiler I am getting back reads and writes of all 0's which obviously can't be. Should have stellar performance, but still the same disk pressure when running perfmon. Stumped on this one. System logs don't indicate anything unusual with the server. Any ideas?
October 5, 2010 at 10:52 am
FYI: There is a forum section for SQL Server 2000
Shawn Melton
Twitter: @wsmelton
Blog: wsmelton.github.com
Github: wsmelton
October 5, 2010 at 11:19 am
Continues: http://www.sqlservercentral.com/Forums/Topic998574-65-1.aspx
No further replies to this thread please.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 5, 2010 at 3:29 pm
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply