Forum Replies Created
Viewing 5 posts - 1 through 6 (of 6 total)
-
RE: SQL 2008 R2 performance monitoring and troubleshooting
So heres what i have, this was taken at 3:50pm
4:30pm (only chance i got to get back on the server)
-
RE: SQL 2008 R2 performance monitoring and troubleshooting
Will do, that's coming up in about 2 hrs, Ill let you know, thanks for the help. I'm going through the articles again and it actually is making sense...
-
RE: SQL 2008 R2 performance monitoring and troubleshooting
SQLSACT (5/21/2013)
What is among your top waits?This is the result of the query, keeping in mine this is not the peak hours of use with our systems
-
RE: SQL 2008 R2 performance monitoring and troubleshooting
GilaMonster (5/21/2013)
jeremy.jamieson (5/21/2013)
It seems in the first step its pulling the same statistics the PAL program i used disk I/O, CPU, memory ect,No, it's not.
PAL pulls the disk, CPU, memory...
-
RE: SQL 2008 R2 performance monitoring and troubleshooting
SQLSACT (5/21/2013)
Have a look at the wait statistics on the serverThanks I will try that now.
GilaMonster (5/21/2013)
http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/I've read through the links, thanks. It seems in the first step its...
Viewing 5 posts - 1 through 6 (of 6 total)