SQL Server Performance Forum – Threads Archive
SQL Server Performance Counter Fetch
In our Organization Oracle DBA Team, fetch the schedule report from Database which consists of :<br />1) Buffer Cache Hit Ratio <br />2) Database Growth in Last 10 Days<br />3) Invalid Objects<br />4) Chained Rows analysis<br />5) Top 10 SQL by Buffer Gets<br />6) Top 10 SQL by Physical Reads<br />7) Top 10 SQL by Executions<br /><img src=’/community/emoticons/emotion-11.gif’ alt=’8)’ /> Free Space in Tablespace<br />9) Check For Max Extents Indexes<br />10) Check For Max Extents Tables<br />11) Check For Max Extents Temporary<br />12) Check For Sessions<br />13) Check For Process<br />14) Check For Locks<br />15) SGA Cache Statistics<br />16) Init parameter Statistics<br />17) Fragmentation in Tablespace<br /><br />Can you please help me to map these report with SQL Server Database?<br />How can I fetch the same kind of report from SQL Server?<br /><br />I will be grateful if you please help me.<br /><br />you really expect us to do all of your work for you? If you ask specifc well thought out questions you are more likley to get a response. Bert
I think you will need a third party tool
But I Wonder whether there is tool which provides each and every thing
try with IDERA sql diagnostic manager and speed coefficient. review for the one prodcut is available
http://www.sql-server-performance.com/da_coefficient_spotlight.asp —————————————-
Cast your vote
http://www.geocities.com/dineshasanka/sqlserver05.html http://spaces.msn.com/members/dineshasanka
Ok Fine …………
Can you give me solution of how to get the below 3 counters from SQL Server Database
1) Top 10 SQL by Buffer Gets
2) Top 10 SQL by Physical Reads
3) Top 10 SQL by Executions This is a discussion forum everybody get the knowledge not only me.
And the above mentioned counter will help every SQL DBA not only me.
http://www.veritas.com/Products/www?c=product&refId=317
You "could" use Profiler for Physical Reads and Executions. You might want to look at Quest Foglight. There isn’t a counter for "Top 10" of anything that I’m aware of. MeanOldDBA
[email protected] When life gives you a lemon, fire the DBA.
]]>