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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy