August 22, 2013 at 6:10 am
Hi All,
We have Performance issue on of our Pord server 2005,where we are seeing I/O issues.While montring i could a high I/O values for the Database.
Database i/o
counter name location value
ISOstall[ms]/read request xxxx(database) 25
I think the database is causing performance is issue.
can any one help me how to troubleshoot this issue ......what is cause for high I/o issue.
Thanks.....in advance..
August 22, 2013 at 10:43 am
August 22, 2013 at 2:36 pm
bala2 (8/22/2013)
Hi All,We have Performance issue on of our Pord server 2005,where we are seeing I/O issues.While montring i could a high I/O values for the Database.
Database i/o
counter name location value
ISOstall[ms]/read request xxxx(database) 25
I think the database is causing performance is issue.
can any one help me how to troubleshoot this issue ......what is cause for high I/o issue.
Thanks.....in advance..
why are you saying is an I/O issue?
Have you checked page life expectancy, RAM and CPU utilization? Have you collected the data during high peaks and for long period of times? Do you have a baseline (how was before) that makes you think is worse now? Is a query or store procedure currently running that is using lot of I/O?
August 22, 2013 at 4:07 pm
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply