Skip to main content

Tips: How to monitor SQL Server Performance and Activity using the built-in functions

We can even find a set of built-in functions that return system information apart from the use of the log files and Transact-SQL statements. In this article, let’s have an overview of the key built-in functions and their usages. The values returned by these functions are cumulative from the time SQL Server was last started.

































FunctionDescriptionExample
@@connectionsReturns the number of connections or attempted connectionsselect @@connections as 'Total Login Attempts'
@@cpu_busyReturns CPU processing time in milliseconds for SQL Server activityselect @@cpu_busy as 'CPU Busy', getdate() as 'Since'
@@idleReturns SQL Server idle time in millisecondsselect @@idle as 'Idle Time', getdate() as 'Since'
@@io_busyReturns I/O processing time in millisecondsselect @@io_busy as 'IO Time', getdate() as 'Since' for SQL Server
@@pack_receivedReturns the number of input packets read from the network by SQL Serverselect @@pack_received as 'Packets Received'








































@@pack_sentReturns the number of output packets written to the network by SQL Serverselect @@pack_sent as 'Packets Sent'
@@packet_errorsReturns the number of network packet errors for SQL Server connectionsselect @@packet_errors as 'Packet Errors'
@@timeticksReturns the number of microseconds per CPU clock tickselect @@timeticks as 'Clock Ticks'
@@total_errorsReturns the number of disk read/write errors encountered by SQL Serverselect @@total_errors as 'Total Errors', getdate() as 'Since'
@@total_readReturns the number of disk reads by SQL Serverselect @@total_read as 'Reads', getdate() as 'Since'
@@total_writeReturns the number of disk writes by SQL Serverselect @@total_write as 'Writes', getdate() as 'Since'
fn_virtualfilestatsReturns input/output statistics for data and log filesselect * from fn_virtualfilestats(null,null)

B y

Popular posts from this blog

New Micro battery, power packed for high performance

For a size of a few millimetres, the new micro-batteries are powerful enough to jump start a car battery and then quickly charge the cell phone. Researchers from the University of Illinois have developed the micro batteries which can be used to drive compact electronic devices and new applications for radio communications. The micro batteries are so good that they can even out power the super capacitors. The results were published in ‘Nature Communications’ in the April 16 issue. The micro batteries have energy and power and with the researchers tweaking the structure of the micro batteries a little bit, its use can be for wide range applications.

The high performance of the micro battery is based on its 3-dimensional micro-structure. Based on the design of fast charging cathode by Professor Paul Braun’s group, researchers developed the matching anode and integrated it with the fast charging cathode at a micro-scale and made a complete battery with high performance. These batteries cou…

HTC Touch Diamond SmartPhone!

The phones design is an innovative in which the user has the geometric form language to make sure a clutter-free environment for screening content. The San Francisco based studio One & Co collaborated with HTC Taiwan Design team to create Diamond HTC smartphone.







The HTC phone is quite wonderful with design and the rapid development in the smartphone market the HTC has taken innovative steps to capture the SmartPhone market HTC develops these kind of new inventive designs.
Inspired

How to Automatically Convert any RSS Feed to an iPhone Web app!

For iPhone users this is another web app which converts any well formed XML RSS feed to an iPhone version. It is possible because it is worked with the typical sliding style interface to suit the iPhone optimized version. For instance if you had the iPhone right now here is the Google News Feed




Jim Liddle, one of the creators of the service, told iPhone Atlas “You can book mark the generated site and use it to host your own content and reference it from your own. It seems that these feed on your iPhone is quiet usable.