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

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

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

Money field

I am using Sql Server reporting services 2000. I have a money field which should show postive or negative amount. I used the format as currency. But it shows as ($40.00) for negative amount(it is placing it in braces) and $40.00 for positive amount. How can I show -$40.00??

HI, Nissan:

You can use this expression instead: =FormatCurrency(Fields!UnitPrice.Value,,,False,)

If i misunderstand you about your question, please feel free to correct me and i will try to help you with more information.

I hope the above information will be helpful. If you have any issues or concerns, please let me know. It's my pleasure to be of assistance

|||

HI, Nissan:

We are marking this issue as "Answered". If you have any new findings or concerns, please feel free to unmark the issue.
Thank you for your understanding!

Money conversion

Hi!

When I write:

'SELECT Amount FROM tTransaktion'

I get returnvalues such as '12000.0000'. Instead, I want it to return '12 000'.

The Amount column is of datatype money. Is this possible!?

Thanks!

select amount, amt, left(amt, len(amt) - 3) as [What you want]
from
(
select amount, replace(convert(varchar(20), amount, 1), ',', ' ') as amt
from
(
select convert(money, 12000) as amount
) a
) b|||

Sure, it's possible using the STR function.

declare @.value money

set @.value = 12000.00

select str(@.value,8,0)

The question is why? It is best to let the user interface handle the display of values and just send back raw values. Also, the money datatype has some issues with roundoff that is covered here: http://www.aspfaq.com/show.asp?id=2503

|||Louis - you're absolutely right -> stupid of me not to let the user interface handle it. Thanks for your answers!|||

Stupid, nah! I still have to fight myself to not format data in SQL since I have control over it and I am addicted to SQL :)

The UI programmers like it too since it is easier on them, but they are also the ones that argue about scalability of the database server, so offloading CPU work like this to them is easier to justify. Plus, you can use the regional settings of the client to display the data as they desire (which is a good thing too.)

|||

If you need commas you can use this

declare @.value money

set @.value = 12000.00

select convert(varchar,@.value,1)

Denis the SQL Menace

http://sqlservercode.blogspot.com/