To see the current performance counter value
Select *from sys.sysperfinfo
Thursday, December 21, 2006
Subscribe to:
Post Comments (Atom)
skip to main |
skip to sidebar
I am an Ex-Sailor from Indian Navy who possesses rich experience in Microsoft SQL Server. I would take this opportunity to pay tribute to all those who serve their country with pride, always keeping “Service before Self”.
About Me
- Madhu K Nair
- I belong to a small village called Cherumundasseri in Pallakkad District of Kerala,India the “Gods Own Country”. I am proud for being an Ex-Sailor from prestigious service of Indian Navy. I owe to Navy for giving me a world class training and a platform to apply my knowledge.
Blog Archive
-
▼
2006
(35)
-
▼
December
(13)
- SysComments v/s sys.sql_modules - Returns differe...
- Maximum Number of Instances by Edition in a Cluste...
- SQL Server Instance-Aware Components SQL Server Co...
- Export/Import Surface area Configuration
- Connect to Remote SQL Server Configuration Manager
- Difference in SQL Server Profiler of 2005 and 2000
- Performance Counter Value from System Table
- Error Severity Level Ranges in SQL Server
- SQL Server DMO and SMO
- FAQ : How to Parameterize TOP clause in SQL Serv...
- Configure SQL 2005 for Remote Access
- Implementation and usage of DDL Trigger and its sa...
- Monitoring Memory Requirement
-
▼
December
(13)
Labels
- Advantage of Disadvantage of Table Partitioning (1)
- ALTER Database (1)
- Data import (1)
- Excel 2007 (1)
- FAQ (37)
- Guidelines for table partitioning (2)
- Horizontal Partition (1)
- How to create files from images stored in database (1)
- openrowset (1)
- Table Partition (6)
- Vertical Partition (1)
- WITH NOWAIT (1)
- WITH ROLLBACK IMMEDIATE (1)
Posts
No comments:
Post a Comment