All Questions
2
questions
4
votes
1
answer
2k
views
High disk time on SQL Server
We have a dedicated SQL Server 2008 R2 Enterprise Edition.
The setup is:
D: (data files) - stored on local ssd disks (not the same disks as log files) (raid 10)
E: (log files) - stored on local ssd ...
0
votes
2
answers
230
views
What types of IO does SQL trace display?
Are they physical or logical IOs? If they're logical, is there a way to break it out similar to STATISTICS IO for a production server?