Wednesday, March 7, 2012

Monitor network traffic per database

Is it possible to monitor incoming and outgoing network
traffic on a database level? I could only find counters
on server level.
Thanks in advance.
HolgerNot from any network monitor... about the best you can do is to use
profiler. You can see selects, etc and the number of rows returned...
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Holger" <holger.haeffelin@.arcworx.net> wrote in message
news:0cd801c3d52e$6122d330$a101280a@.phx.gbl...
> Is it possible to monitor incoming and outgoing network
> traffic on a database level? I could only find counters
> on server level.
> Thanks in advance.
> Holger|||Yes. All the performance counters are at a SQL Server level. Not at a
database specific level. The only thing that comes to my mind is wrt to the
IO operations that can be monitored if you can group filegroups of a
specific database into a single disk and monitor the Disk IO of the specific
disk. This is the max. I've seen implemented. But other parameters are can
be monitored using the profiler as Wayne said ...
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Holger" <holger.haeffelin@.arcworx.net> wrote in message
news:0cd801c3d52e$6122d330$a101280a@.phx.gbl...
> Is it possible to monitor incoming and outgoing network
> traffic on a database level? I could only find counters
> on server level.
> Thanks in advance.
> Holger

No comments:

Post a Comment