troubleshooting Question

Performance Stats on SQL 2005 & SQL2008

Avatar of compdigit44
compdigit44 asked on
Microsoft SQL Server
7 Comments1 Solution316 ViewsLast Modified:
I have two seperation SQL servers: One is running Windows 2003 SQL 2005 & the other is Windows 2008 R2 SQL 2008. I would like to find out the following information from both servers:

1) Number of totally DB connections to each server.
2) Memory IO stats - what is consider high or low I'm not a DB person myself
3) Disk IO stats - what is consider high or low
4) PAge file stats
ASKER CERTIFIED SOLUTION
lcohan
Database Analyst
Join our community to see this answer!
Unlock 1 Answer and 7 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 7 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros