Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to get these details in sqlserver Expand / Collapse
Author
Message
Posted Friday, April 19, 2013 5:31 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 10, 2014 1:53 AM
Points: 591, Visits: 1,332
HI all,
1. CPU and Memory Utilization for Last 15 days of DB server and Application server
2. Top Costly Query by Average IO during pick our.
3. Top Costly Query by Average CPU during pick our.
4. Top 40 Tables size and its indexs name.
5. All 40 tables indexes fragmentation % value.
6. Update Stats Status Log for database a1 & a2.
7. Buffer Cache Hit Ratio Output Graph for Last 15 days of DB server.


Thanks
Naga.Rohitkumar
Post #1444322
Posted Friday, April 19, 2013 5:44 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Yesterday @ 2:35 PM
Points: 12,962, Visits: 32,498
interview questions?


Lowell

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son
Post #1444330
Posted Friday, April 19, 2013 7:38 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Yesterday @ 8:36 AM
Points: 40,615, Visits: 37,080
1 and 7 - google "performance monitor"
2 and 3, google "query plan cache stats" or "SQL profiler"
4 google "catalog views"
5 google "index fragmentation DMV"



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1444396
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse