Database perf counters on SQL server. | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Database perf counters on SQL server.

Is it possible to know the processor utilization and memory footprint of an individual database in a SQL server? Jerry Nixon
DMVs are helpful in this case and you can use sys.dm_db_session_space_usage, fyi referhttp://sqlknowledge.com/index.php?option=com_content&task=view&id=68&Itemid=41 link. 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.
That’s file size info, right? Any way to get processor util? Jerry Nixon
I don’t think you get the processor util. through tsql/dmv…
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

To some extent you can using few DMVs –http://blogs.msdn.com/slavao/archive/2006/08/22/713357.aspx further information on DMVs, also refer to SQL 2005 Books online(updated). 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.
]]>