|
Hi, I/O operations are distributed over the data files and log files and wait time per read(ms) is very high in my environment SQL server 2005.how can we improve the wait time per read(ms). Please suggest Regards, Sudhakar
(comments are locked)
|
|
Yes...data files and log files are residing on different drives which are SAN and tables are spread the across the datafiles
(comments are locked)
|
|
No multiple instances adn databases and fragmenting the indexes based on average fragmentation value on every sunday
(comments are locked)
|
« previous 1 2
Your answer
