High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,Have you applied the post-SP3a hotfix?
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fix
- are you referring to SP4?
"Tom Moreau" wrote:
> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becoming
> a bit of a pain for our poor network guys. The other odd thing is that the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
--
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:
> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,Have you applied the post-SP3a hotfix?
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fi
x
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from o
ne
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to th
e
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becomi
ng
> a bit of a pain for our poor network guys. The other odd thing is that th
e
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cu
ll
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
Tom
----
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
.
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High Volume of Net Traffic coming from MSSQL

We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,
Have you applied the post-SP3a hotfix?
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
We're having a bit of an issue with network traffic being generated from one
of our MSSQL Servers.
It seems that when we launch Enterprise Manager on a remote computer
(usually at another office), the MSSQL servers start sending packets to the
EM regardless of whether we are maintaining an active connection to the
server or not. What is happening is that these packets are being lost and
reported in our firewall as 'host unreachable'. These packets are also
firing every second for each EM open across our network, so this is becoming
a bit of a pain for our poor network guys. The other odd thing is that the
firewall is only reporting one-way traffic, from the server to the client,
but the client is not sending any traffic back down unless it is actively
connected to the remote server.
Any thoughts as to why this might be happening, or better yet, a way to cull
this traffic?
We're running MSSQL 2000 SP3a on Windows 2003 servers.
Thanks in advance!
Mike,
|||We have the entire SP3a hotfix installed, but I am unaware of a post SP3a fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is becoming
> a bit of a pain for our poor network guys. The other odd thing is that the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>
|||Define "entire SP3a hotfix". There is the service pack - SP3a - and then
there is the hotfix. Are you saying that you have applied SP3a but not the
hotfix? IOW, have you applied:
http://support.microsoft.com/kb/821277
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Toronto, ON Canada
..
"Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
news:5D90B16F-7EDB-401C-8022-106365D44347@.microsoft.com...
We have the entire SP3a hotfix installed, but I am unaware of a post SP3a
fix
- are you referring to SP4?
"Tom Moreau" wrote:

> Have you applied the post-SP3a hotfix?
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
> SQL Server MVP
> Toronto, ON Canada
> ..
> "Mike Schurkin" <MikeSchurkin@.discussions.microsoft.com> wrote in message
> news:C948BB2C-1A9D-4B73-9BDF-72B74A1FA9A2@.microsoft.com...
> We're having a bit of an issue with network traffic being generated from
> one
> of our MSSQL Servers.
> It seems that when we launch Enterprise Manager on a remote computer
> (usually at another office), the MSSQL servers start sending packets to
> the
> EM regardless of whether we are maintaining an active connection to the
> server or not. What is happening is that these packets are being lost and
> reported in our firewall as 'host unreachable'. These packets are also
> firing every second for each EM open across our network, so this is
> becoming
> a bit of a pain for our poor network guys. The other odd thing is that
> the
> firewall is only reporting one-way traffic, from the server to the client,
> but the client is not sending any traffic back down unless it is actively
> connected to the remote server.
> Any thoughts as to why this might be happening, or better yet, a way to
> cull
> this traffic?
> We're running MSSQL 2000 SP3a on Windows 2003 servers.
> Thanks in advance!
> Mike,
>

High performance isn't always an advantage...

Hello
MSSQL 2000 + SP3 on Windows 2000 AS + SP4
I've moved my databases to new server.
IO subsystem now TEN times faster!
I have the system of two jobs performing defragmentation
of my data. One of the jobs issues DBCC INDEXDEFRAG
statements and the second one monitors state of transaction
log and stops first job if log more than 70% full. SQLAgent
can run jobs only with 1 minute intervals. So I can monitor
log status only once in minute. Everything was all right at old
server. Now on new hardware log overfills in couple of seconds
and monitoring job can't catch the moment of overfilling and
correctly stop the defragmentation.
Two questions:
1. Should I increase Tlog size depending on hardware performance
2. Is there any way to monitor log state more ofter than once
in a minute?
Thanks.
Serge ShakhovYou can have a job which uses an endless loop and WAITFOR with, say, 10 seconds.
--
Tibor Karaszi, SQL Server MVP
Archive at: http://groups.google.com/groups?oi=djq&as ugroup=microsoft.public.sqlserver
"Serge Shakhov" <REMOVETHIS_ACETYLENE@.mail.ru> wrote in message
news:83ndmb.5kr.ln@.proxyserver.ctd.mmk.chel.su...
> Hello
> MSSQL 2000 + SP3 on Windows 2000 AS + SP4
> I've moved my databases to new server.
> IO subsystem now TEN times faster!
> I have the system of two jobs performing defragmentation
> of my data. One of the jobs issues DBCC INDEXDEFRAG
> statements and the second one monitors state of transaction
> log and stops first job if log more than 70% full. SQLAgent
> can run jobs only with 1 minute intervals. So I can monitor
> log status only once in minute. Everything was all right at old
> server. Now on new hardware log overfills in couple of seconds
> and monitoring job can't catch the moment of overfilling and
> correctly stop the defragmentation.
> Two questions:
> 1. Should I increase Tlog size depending on hardware performance
> 2. Is there any way to monitor log state more ofter than once
> in a minute?
> Thanks.
> Serge Shakhov
>|||Hello
> You can have a job which uses an endless loop and WAITFOR with, say, 10
seconds.
That's a good idea!
But I'll try to avoid cycling process by executing every minute job wich
will last 58-59 seconds and perform checks say every 5 seconds...
Thank you Tibor.
Serge Shakhovsql

High CPU Usage

Hello,
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo Sicouret
You can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:

> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certain
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>
|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribi en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...[vbcol=seagreen]
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to see
what command is being executed for that spid.
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:

> I get that SQL server is the process that's taking the most CPU time... but
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
>
>

High CPU Usage

Hello,
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo SicouretYou can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:

> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certa
in
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribi en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...[vbcol=seagreen]
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
>|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to se
e
what command is being executed for that spid.
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:

> I get that SQL server is the process that's taking the most CPU time... b
ut
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
>
>

High CPU Usage

Hello,
I need your help urgently.
I have a MsSQL server database that behaves normally all day, but at certain
times the server's cpu usage rises abnormally.
There's no increase in the amount of transactions sent to the server,
there's no scheduled job running, and apparently there's no other
application running on the server.
Could you tell me the tools availble to identify what's the cause of the
high CPU usage? with Perfomance monitor I get the %Processor Time but I
don't get the source of the problem.
Any ideas,
TIA
Eduardo SicouretYou can go into task manager and select the "Processes" tab. Once there
click the CPU column to sort it... this should show you which
process/application is using the CPU the most.
HTH
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> Hello,
> I need your help urgently.
> I have a MsSQL server database that behaves normally all day, but at certain
> times the server's cpu usage rises abnormally.
> There's no increase in the amount of transactions sent to the server,
> there's no scheduled job running, and apparently there's no other
> application running on the server.
> Could you tell me the tools availble to identify what's the cause of the
> high CPU usage? with Perfomance monitor I get the %Processor Time but I
> don't get the source of the problem.
> Any ideas,
> TIA
> Eduardo Sicouret
>
>|||I get that SQL server is the process that's taking the most CPU time... but
I don't know what is it doing
Eduardo
"Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
> You can go into task manager and select the "Processes" tab. Once there
> click the CPU column to sort it... this should show you which
> process/application is using the CPU the most.
> HTH
> --
> Adam J Warne, MCDBA
>
> "Eduardo Sicouret" wrote:
>> Hello,
>> I need your help urgently.
>> I have a MsSQL server database that behaves normally all day, but at
>> certain
>> times the server's cpu usage rises abnormally.
>> There's no increase in the amount of transactions sent to the server,
>> there's no scheduled job running, and apparently there's no other
>> application running on the server.
>> Could you tell me the tools availble to identify what's the cause of the
>> high CPU usage? with Perfomance monitor I get the %Processor Time but
>> I
>> don't get the source of the problem.
>> Any ideas,
>> TIA
>> Eduardo Sicouret
>>|||My apologies Eduardo, I misread the question ... one of those days.
In this instance, you could run a trace through SQL profiler to see what
transactions are running when the CPU usage peaks.
Alternatively, you can execute "sp_who2" and this will show you the spids
that have a high CPU time. You can then run "dbcc inputbuffer (spid)" to see
what command is being executed for that spid.
--
Adam J Warne, MCDBA
"Eduardo Sicouret" wrote:
> I get that SQL server is the process that's taking the most CPU time... but
> I don't know what is it doing
> Eduardo
> "Adam Warne" <AdamWarne@.discussions.microsoft.com> escribió en el mensaje
> news:AE07D8AD-7AAA-40F0-86B2-0CBA02854D42@.microsoft.com...
> > You can go into task manager and select the "Processes" tab. Once there
> > click the CPU column to sort it... this should show you which
> > process/application is using the CPU the most.
> >
> > HTH
> > --
> > Adam J Warne, MCDBA
> >
> >
> > "Eduardo Sicouret" wrote:
> >
> >> Hello,
> >>
> >> I need your help urgently.
> >>
> >> I have a MsSQL server database that behaves normally all day, but at
> >> certain
> >> times the server's cpu usage rises abnormally.
> >>
> >> There's no increase in the amount of transactions sent to the server,
> >> there's no scheduled job running, and apparently there's no other
> >> application running on the server.
> >>
> >> Could you tell me the tools availble to identify what's the cause of the
> >> high CPU usage? with Perfomance monitor I get the %Processor Time but
> >> I
> >> don't get the source of the problem.
> >>
> >> Any ideas,
> >>
> >> TIA
> >>
> >> Eduardo Sicouret
> >>
> >>
> >>
>
>