SQL Server Performance Forum – Threads Archive
how to fine pages read and wrote per minutes
Hi All, Can any tell me how to find out the total number pages read/min and pages write /min on a database in sql server. How can we know also the number of connections and user to that database. thanks in advanceIt is hard to tell…per database bases… For connection info…
You can check the following DMVs…
sys.dm_exec_connections
sys.dm_exec_sessions
sys.dm_exec_requests
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
You could take help of DMV sys.dm_db_session_space_usage upto some extent. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Can I know how to find pages read/min and pages wrote/min on the SQL SERVER as a whole? If Yes Let me know the procedure to find out this? Do we need any third party tool for this?
Thanks in Advance
Have you tried with above DMV or what was the result? Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>