We currently have a large database - 64GB Data file, (which I know could be split into different data files).
Our indexing job is taking between 4.5 - 5 hrs long, as we use dbcc dbreindex , this can have an impact on other tasks.
We have SAN IO figures using SQLIO tool - write performance of 4MB/s, which my local hard disc operates at 2M/s.
Can anyone let me know if they have encountered similiar indexing issues and IO issues and if so what way they went about identifying and resolving the issues.
Here is some of the things we have done to date:
Run SQL IO stress tests.
Added additional LUNs to the SAN and allocated them to the drive which the datafile is stored on.
Replaced discs on SAN
Any help appreciated.
"I'm living so far beyond my income that we may almost be said to be living apart
Our indexing job is taking between 4.5 - 5 hrs long, as we use dbcc dbreindex , this can have an impact on other tasks.
We have SAN IO figures using SQLIO tool - write performance of 4MB/s, which my local hard disc operates at 2M/s.
Can anyone let me know if they have encountered similiar indexing issues and IO issues and if so what way they went about identifying and resolving the issues.
Here is some of the things we have done to date:
Run SQL IO stress tests.
Added additional LUNs to the SAN and allocated them to the drive which the datafile is stored on.
Replaced discs on SAN
Any help appreciated.
"I'm living so far beyond my income that we may almost be said to be living apart