System statistical functions are nondeterministic functions that return the information about the performance of the SQL Server. Some of the system statistical functions along with their return values are tabulated in the following table:
| Function | Return value |
|---|---|
| @@CPU_BUSY | Returns the time that SQL Server has spent working since it was last started. |
| @@IDLE | Returns the time that SQL Server has been idle since it was last started. |
| @@CONNECTIONS | Returns the number of attempted connections, either successful or unsuccessful since SQL Server was last started. |
| @@TOTAL_READ | Returns the number of disk reads by SQL Server since SQL Server was last started. |
| @@TOTAL_WRITE | Returns the number of disk writes by SQL Server since SQL Server was last started. |
| @@TOTAL_ERRORS | Returns the number of disk write errors encountered by SQL Server since SQL Server was last started. |
- Best exam simulation Microsoft mcad download free trial.
- Best exam simulation Microsoft mcp download free trial.
- Click here to get free mcsa-2000-to-2003 MCSA 2000 to 2003 exam practice questions.
- Click here to get free mcsa-to-mcse-2003 MCSA to MCSE-2003 exam practice questions.
- Pass Microsoft mcse-2003 - MCSE
- Download practice question and study guide for mcts-sql-server-2005 for exam.
- Click here to get free 70-431 SQL Server 2005 Implementation exam practice questions.
Like this article? Share it with others
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.
If you like this article, please leave a comment or subscribe this blog via RSS or via e-mail, Bookmark and share through your network. Click the AddThis button below. Thanks.