Why is my logical disk usage enormous?
Home > IT Answers > SQL Server > Why is my logical disk usage enormous?
SQL Server Ask the Experts
2445 pts.
0
Q:
Why is my logical disk usage enormous?
logical disk, SQL Server 2005, performance tuning
I have a cluster
server (2003 OS) in my environment with SQL Server 2005. It has four internal
disks with RAID 10 configurations. My logical disk usage is pretty high and I am not sure how to find out what exactly is “hammering” our server
or what database is making this disk activity enormous. I would appreciate any advice pointing me in the right the direction on how to narrow down the issue. I checked
the performance and tuning on this server but to no avail.


Software/Hardware used:
SQL Server 2005
ASKED: Nov 9 2009  2:19 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Mrdenny
47440 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Usually this is caused by a lack of indexes in the database.
Last Answered: Nov 10 2009  6:20 AM GMT by Mrdenny   47440 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



0