Dear All,
I have 2 SQL Server 2000 computers. Each server contains data for one of
regional divisions. Company employees currently use a single data entry
application on client
computers. After the new application is installed, query response times
slow. My IT Manager ask me to monitor server traffic during business
hours to help him diagnose this problem. What should I do?
Thanks
Robert LieHi,
You can install a tool like MRTG to monitor network traffic or use the
windows performance monitor to track the number of bytes send/received per
second.
Erik
"robert lie" <robert.lie24@.gmail.com> wrote in message
news:OoShX$RZFHA.2884@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 SQL Server 2000 computers. Each server contains data for one of
> regional divisions. Company employees currently use a single data entry
> application on client
> computers. After the new application is installed, query response times
> slow. My IT Manager ask me to monitor server traffic during business
> hours to help him diagnose this problem. What should I do?
> Thanks
> Robert Lie
Showing posts with label traffic. Show all posts
Showing posts with label traffic. Show all posts
Monday, March 12, 2012
Monitoring netwrok traffic
Dear All,
I have 2 SQL Server 2000 computers. Each server contains data for one of
regional divisions. Company employees currently use a single data entry
application on client
computers. After the new application is installed, query response times
slow. My IT Manager ask me to monitor server traffic during business
hours to help him diagnose this problem. What should I do?
Thanks
Robert LieHi,
You can install a tool like MRTG to monitor network traffic or use the
windows performance monitor to track the number of bytes send/received per
second.
Erik
"robert lie" <robert.lie24@.gmail.com> wrote in message
news:OoShX$RZFHA.2884@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 SQL Server 2000 computers. Each server contains data for one of
> regional divisions. Company employees currently use a single data entry
> application on client
> computers. After the new application is installed, query response times
> slow. My IT Manager ask me to monitor server traffic during business
> hours to help him diagnose this problem. What should I do?
> Thanks
> Robert Lie
I have 2 SQL Server 2000 computers. Each server contains data for one of
regional divisions. Company employees currently use a single data entry
application on client
computers. After the new application is installed, query response times
slow. My IT Manager ask me to monitor server traffic during business
hours to help him diagnose this problem. What should I do?
Thanks
Robert LieHi,
You can install a tool like MRTG to monitor network traffic or use the
windows performance monitor to track the number of bytes send/received per
second.
Erik
"robert lie" <robert.lie24@.gmail.com> wrote in message
news:OoShX$RZFHA.2884@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 SQL Server 2000 computers. Each server contains data for one of
> regional divisions. Company employees currently use a single data entry
> application on client
> computers. After the new application is installed, query response times
> slow. My IT Manager ask me to monitor server traffic during business
> hours to help him diagnose this problem. What should I do?
> Thanks
> Robert Lie
Monitoring netwrok traffic
Dear All,
I have 2 SQL Server 2000 computers. Each server contains data for one of
regional divisions. Company employees currently use a single data entry
application on client
computers. After the new application is installed, query response times
slow. My IT Manager ask me to monitor server traffic during business
hours to help him diagnose this problem. What should I do?
Thanks
Robert Lie
Hi,
You can install a tool like MRTG to monitor network traffic or use the
windows performance monitor to track the number of bytes send/received per
second.
Erik
"robert lie" <robert.lie24@.gmail.com> wrote in message
news:OoShX$RZFHA.2884@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 SQL Server 2000 computers. Each server contains data for one of
> regional divisions. Company employees currently use a single data entry
> application on client
> computers. After the new application is installed, query response times
> slow. My IT Manager ask me to monitor server traffic during business
> hours to help him diagnose this problem. What should I do?
> Thanks
> Robert Lie
I have 2 SQL Server 2000 computers. Each server contains data for one of
regional divisions. Company employees currently use a single data entry
application on client
computers. After the new application is installed, query response times
slow. My IT Manager ask me to monitor server traffic during business
hours to help him diagnose this problem. What should I do?
Thanks
Robert Lie
Hi,
You can install a tool like MRTG to monitor network traffic or use the
windows performance monitor to track the number of bytes send/received per
second.
Erik
"robert lie" <robert.lie24@.gmail.com> wrote in message
news:OoShX$RZFHA.2884@.tk2msftngp13.phx.gbl...
> Dear All,
> I have 2 SQL Server 2000 computers. Each server contains data for one of
> regional divisions. Company employees currently use a single data entry
> application on client
> computers. After the new application is installed, query response times
> slow. My IT Manager ask me to monitor server traffic during business
> hours to help him diagnose this problem. What should I do?
> Thanks
> Robert Lie
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
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
Monitor Network traffic
I would like to know how much network traffic I am using between my client
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanks
Hi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanks
Hi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks
Monitor Network traffic
I would like to know how much network traffic I am using between my client
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanksHi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanksHi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks
Monitor Network traffic
I would like to know how much network traffic I am using between my client
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanksHi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks
and SQL Server. What would be a good tool to capture the total amount of
traffic?
thanksHi,
Network Performance Counters
One of the best ways to monitor if you have a network bottleneck is to watch
the "Network Interface Object: Bytes Total/Sec" counter. This counter
measures the number of bytes that are being sent back and forth between your
server and the network. This includes both SQL Server and non-SQL Server
network traffic. Assuming your server is a dedicated SQL Server, then the
vast majority of the traffic measured by this counter should be from SQL
Server.
There is no hard and fast "correct" number for this counter as it measures
the actual traffic. To help you decide if your server has a network
bottleneck, one way to use this number is to compare it with the maximum
traffic supported by the network connection your server is using. Also, this
is another important counter to watch over time. It is important to know if
your network traffic is increasing regularly. If it is, then you can use
this information to help you plan for future hardware needs.
If your SQL Server is experiencing network bottlenecks, consider these
possible solutions:
a.. Add faster network cards.
b.. Add additional network cards.
c.. Server network card should be attached to switches.
d.. Network cards should be running in full duplex mode.
e.. Tune your application so that it does not require unnecessary network
trips. Do this by returning only the required data and used stored
procedures.
f.. Remove all unnecessary network protocols from the server.
g.. Use TCP/IP as the network library on the client and server.
Before you can use the network performance counters, the Network Monitor
Agent service must be installed on your server. After installing it, you
will have to reboot. Also, don't forget to rerun the latest NaT service pack
to update the files added during the installation process.
Take a look into the MS tools available
http://msdn2.microsoft.com/en-us/library/ms179428.aspx
Thanks
Hari
SQL Server MVP
"John Grant" <JohnGrant@.discussions.microsoft.com> wrote in message
news:950901AE-F368-4B9A-A523-47E1D5A8FD87@.microsoft.com...
>I would like to know how much network traffic I am using between my client
> and SQL Server. What would be a good tool to capture the total amount of
> traffic?
> thanks
Subscribe to:
Posts (Atom)