Saturday, 20 September 2008

Disk System Pressure

Woah!!!!! This sql instance is really struggling with I/O >

The steps I took to rectify this were >
1) File Defragmentation (well I moved the files off and back on to the disk as it was quicker)
2) Data Defragmentation (implemented a deframentation job & scheduled it)
3) Moved tempdb to a separate physical disk

No comments: