Forum Search:
Forum.Brain-Cluster.com: Brain Cluster Technical Forum
Ultimate forum for Technical Discussions

Home » Latest Technology Update and Announcement » TechNet Magazine » SQL Server: Get A Traffic Report: Analyze Your Database Usage With System Tables (TechNet Magazine)
SQL Server: Get A Traffic Report: Analyze Your Database Usage With System Tables [message #288689] Tue, 03 May 2005 03:00
TechNet Magazine  is currently offline TechNet Magazine  United States
Messages: 1629
Registered: November 2004
Senior Member

By querying data from the master.sysprocesses table you can get almost any information you need about connections to your SQL database, what each process is doing, which processes are blocking, and lots more. Then you can use this data to create some truly enlightening reports.

Matt Evans and Josh Moody

TechNet Magazine Spring 2005

Goto Forum:
  


Current Time: Sun Jun 25 16:51:04 EDT 2017

Total time taken to generate the page: 0.02662 seconds
.:: Contact :: Home ::Sitemap::.

Powered by: FUDforum 3.0.0RC2.
Copyright ©2001-2009 FUDforum Bulletin Board Software