I think I can use NetMon to monitor traffic (b,kb,mb, gb) of my db (to/from) , however I dont know how to get a summary and breakdown of the traffic size.
Has anyone used Netmon for this and can either explain how or point me in the right direction.
Everything is local in my scenario , I just want to know the bandwidth usage of the db calls.
Are you trying to find the bytes sent/received from a particular query, or the amount of bandwidth being used for all queries under a given load?
If you want to get an idea of the bytes sent/received for a single query, just turn on "Include client statistics" under the Query menu in SQL Management studio.
If you want to see the network utilization under a load, the easiest way would be to generate a load from another machine and then use perfmon on the DB server and add the counters for the Network Interface s bytes sent/received to monitor the actual utilization.
If you are limited to one machine then you might be able to try something that can isolate a single processes network traffic, like netlimiter
If your using SqlConnection from ADO.Net you can use the provider statistics to get the total number of bytes received and sent.
I m trying to export some tables from SQL Server 2005 and then create those tables and populate them in Oracle. I have about 10 tables, varying from 4 columns up to 25. I m not using any constraints/...
In our database we have an SQL server account that has the correct roles to access some of the databases. We are now switching to windows authentication and I was wondering if we can create a NT user ...
I have been trying to execute a MS SQL Server stored procedure via JDBC today and have been unsuccessful thus far. The stored procedure has 1 input and 1 output parameter. With every combination I ...
Is it possible to use the sqlcmd command to dump table structure the way it can be done with mysqldump?
Hi I have the following SP, however when I use LINQ to SQL it generates 2 multiple recordsets. For my sanity I am trying to fathom out what it is in the stored procedure that is doing this and would ...
I want to create a table in MS SQL Server 2005 to record details of certain system operations. As you can see from the table design below, every column apart from Details is is non nullable. CREATE ...
I love the new DATE datatype in SQL Server 2008, but when I compare a DATE field to a DATETIME field on a linked server (SQL 2005, in this case), like this: DECLARE @MyDate DATE SET @MyDate = CONVERT(...
How to determine if a Transaction is active i.e. before issuing Begin Transaction I want to ensure that no previous transaction are open.. the platform is VB6, MS-SQL Server 2000 and ADO 2.8
