Hello Group,
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
Showing posts with label troubleshoot. Show all posts
Showing posts with label troubleshoot. Show all posts
Thursday, March 8, 2012
CPU Use Rising
Hello Group,
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?
Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?
Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
CPU Use Rising
Hello Group,
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
what is a good starting point setting a trace to troubleshoot CPU usage? My
network admin asked me to look at one of the servers: it seems after our
weekly restarts, the CPU usage keeps rising. What can I begin to look at to
determine what is causing this?Rich,
Start with Task Manager to determine what app is causing the issue. If SQL
Server, then drill down using System Monitor and Profiler.
HTH
Jerry
"Rich" <Rich@.discussions.microsoft.com> wrote in message
news:B55F66D8-C41D-4C04-9BC6-87F176891311@.microsoft.com...
> Hello Group,
> what is a good starting point setting a trace to troubleshoot CPU usage?
> My
> network admin asked me to look at one of the servers: it seems after our
> weekly restarts, the CPU usage keeps rising. What can I begin to look at
> to
> determine what is causing this?
CPU usage and troubleshoot (sp_who2, profiling)
(I have only little knowledge in mssql)
Hello,
We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
sticked at 100% during few hours. The dbs are used by customers, we
didn't designed them, we just manage the system until middleware level
(SQL Server)
We would like to trouble this CPU problem. I use some tricks found on
the net, as the sp_who2, which gave me some details on the commands
run. I have a lot of sleeping process with AWAITING COMMAND; the
sp_who2 reported me also CPU and IO usage but I don't know which
units.
The output is at http://rafb.net/p/DWkMQO35.html
Can I have some pointers on how use th output of sp_who2 to track
performance problems
Thanks for your help
And if you are using SQL2005 SP2, you would find the newly released dashboard
reports rather useful in finding queries that may be consuming excessive CPU.
Linchi
"tabarnak@.gmail.com" wrote:
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>
|||On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Are you on SQL 2000.
> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
> approach I take is normally, to analyse these figures , ascertain whether
> it's an IO or network problem . Then drill down to the db level
> --
> Jack Vamvas
(being away for some days)
Hi Jack,
I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
CXPACKET, LATCH_EX and PAGEIOLATCH_SH
Am I right, could you give some explanatations and hints.
is it possible to clear these stats, in order to have them on a short
sessions, along-side of the profiler for instance.
Thanks
Regards
Hello,
We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
sticked at 100% during few hours. The dbs are used by customers, we
didn't designed them, we just manage the system until middleware level
(SQL Server)
We would like to trouble this CPU problem. I use some tricks found on
the net, as the sp_who2, which gave me some details on the commands
run. I have a lot of sleeping process with AWAITING COMMAND; the
sp_who2 reported me also CPU and IO usage but I don't know which
units.
The output is at http://rafb.net/p/DWkMQO35.html
Can I have some pointers on how use th output of sp_who2 to track
performance problems
Thanks for your help
And if you are using SQL2005 SP2, you would find the newly released dashboard
reports rather useful in finding queries that may be consuming excessive CPU.
Linchi
"tabarnak@.gmail.com" wrote:
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>
|||On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Are you on SQL 2000.
> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
> approach I take is normally, to analyse these figures , ascertain whether
> it's an IO or network problem . Then drill down to the db level
> --
> Jack Vamvas
(being away for some days)
Hi Jack,
I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
CXPACKET, LATCH_EX and PAGEIOLATCH_SH
Am I right, could you give some explanatations and hints.
is it possible to clear these stats, in order to have them on a short
sessions, along-side of the profiler for instance.
Thanks
Regards
CPU usage and troubleshoot (sp_who2, profiling)
(I have only little knowledge in mssql)
Hello,
We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
sticked at 100% during few hours. The dbs are used by customers, we
didn't designed them, we just manage the system until middleware level
(SQL Server)
We would like to trouble this CPU problem. I use some tricks found on
the net, as the sp_who2, which gave me some details on the commands
run. I have a lot of sleeping process with AWAITING COMMAND; the
sp_who2 reported me also CPU and IO usage but I don't know which
units.
The output is at http://rafb.net/p/DWkMQO35.html
Can I have some pointers on how use th output of sp_who2 to track
performance problems
Thanks for your helpAre you on SQL 2000.
Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
approach I take is normally, to analyse these figures , ascertain whether
it's an IO or network problem . Then drill down to the db level
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com
<a href="http://links.10026.com/?link=http://www.itjobfeed.com">uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178200041.682518.327170@.n59g2000hsh.googlegroups.com...
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||And if you are using SQL2005 SP2, you would find the newly released dashboar
d
reports rather useful in finding queries that may be consuming excessive CPU
.
Linchi
"tabarnak@.gmail.com" wrote:
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Are you on SQL 2000.
> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
> approach I take is normally, to analyse these figures , ascertain whether
> it's an IO or network problem . Then drill down to the db level
> --
> Jack Vamvas
(being away for some days)
Hi Jack,
I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
CXPACKET, LATCH_EX and PAGEIOLATCH_SH
Am I right, could you give some explanatations and hints.
is it possible to clear these stats, in order to have them on a short
sessions, along-side of the profiler for instance.
Thanks
Regards|||I went to the link but got a 404
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/sql
<a href="http://links.10026.com/?link=http://www.itjobfeed.com/sql"> uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178703761.778779.133060@.e51g2000hsg.googlegroups.com...
> On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> (being away for some days)
> Hi Jack,
> I uploaded the output in http://rafb.net/p/6rXNqc96.html.
> CXPACKET, LATCH_EX and PAGEIOLATCH_SH
> Am I right, could you give some explanatations and hints.
> is it possible to clear these stats, in order to have them on a short
> sessions, along-side of the profiler for instance.
> Thanks
> Regards
>
Hello,
We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
sticked at 100% during few hours. The dbs are used by customers, we
didn't designed them, we just manage the system until middleware level
(SQL Server)
We would like to trouble this CPU problem. I use some tricks found on
the net, as the sp_who2, which gave me some details on the commands
run. I have a lot of sleeping process with AWAITING COMMAND; the
sp_who2 reported me also CPU and IO usage but I don't know which
units.
The output is at http://rafb.net/p/DWkMQO35.html
Can I have some pointers on how use th output of sp_who2 to track
performance problems
Thanks for your helpAre you on SQL 2000.
Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
approach I take is normally, to analyse these figures , ascertain whether
it's an IO or network problem . Then drill down to the db level
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com
<a href="http://links.10026.com/?link=http://www.itjobfeed.com">uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178200041.682518.327170@.n59g2000hsh.googlegroups.com...
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||And if you are using SQL2005 SP2, you would find the newly released dashboar
d
reports rather useful in finding queries that may be consuming excessive CPU
.
Linchi
"tabarnak@.gmail.com" wrote:
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Are you on SQL 2000.
> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
> approach I take is normally, to analyse these figures , ascertain whether
> it's an IO or network problem . Then drill down to the db level
> --
> Jack Vamvas
(being away for some days)
Hi Jack,
I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
CXPACKET, LATCH_EX and PAGEIOLATCH_SH
Am I right, could you give some explanatations and hints.
is it possible to clear these stats, in order to have them on a short
sessions, along-side of the profiler for instance.
Thanks
Regards|||I went to the link but got a 404
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/sql
<a href="http://links.10026.com/?link=http://www.itjobfeed.com/sql"> uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178703761.778779.133060@.e51g2000hsg.googlegroups.com...
> On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> (being away for some days)
> Hi Jack,
> I uploaded the output in http://rafb.net/p/6rXNqc96.html.
> CXPACKET, LATCH_EX and PAGEIOLATCH_SH
> Am I right, could you give some explanatations and hints.
> is it possible to clear these stats, in order to have them on a short
> sessions, along-side of the profiler for instance.
> Thanks
> Regards
>
CPU usage and troubleshoot (sp_who2, profiling)
(I have only little knowledge in mssql)
Hello,
We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
sticked at 100% during few hours. The dbs are used by customers, we
didn't designed them, we just manage the system until middleware level
(SQL Server)
We would like to trouble this CPU problem. I use some tricks found on
the net, as the sp_who2, which gave me some details on the commands
run. I have a lot of sleeping process with AWAITING COMMAND; the
sp_who2 reported me also CPU and IO usage but I don't know which
units.
The output is at http://rafb.net/p/DWkMQO35.html
Can I have some pointers on how use th output of sp_who2 to track
performance problems
Thanks for your helpAre you on SQL 2000.
Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
approach I take is normally, to analyse these figures , ascertain whether
it's an IO or network problem . Then drill down to the db level
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com
<a href="http://links.10026.com/?link=uk/">http://www.itjobfeed.com">uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178200041.682518.327170@.n59g2000hsh.googlegroups.com...
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||And if you are using SQL2005 SP2, you would find the newly released dashboard
reports rather useful in finding queries that may be consuming excessive CPU.
Linchi
"tabarnak@.gmail.com" wrote:
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Are you on SQL 2000.
> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
> approach I take is normally, to analyse these figures , ascertain whether
> it's an IO or network problem . Then drill down to the db level
> --
> Jack Vamvas
(being away for some days)
Hi Jack,
I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
CXPACKET, LATCH_EX and PAGEIOLATCH_SH
Am I right, could you give some explanatations and hints.
is it possible to clear these stats, in order to have them on a short
sessions, along-side of the profiler for instance.
Thanks
Regards|||I went to the link but got a 404
--
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/sql
<a href="http://links.10026.com/?link=">http://www.itjobfeed.com/sql"> uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178703761.778779.133060@.e51g2000hsg.googlegroups.com...
> On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
>> Are you on SQL 2000.
>> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site.
>> The
>> approach I take is normally, to analyse these figures , ascertain whether
>> it's an IO or network problem . Then drill down to the db level
>> --
>> Jack Vamvas
> (being away for some days)
> Hi Jack,
> I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
> CXPACKET, LATCH_EX and PAGEIOLATCH_SH
> Am I right, could you give some explanatations and hints.
> is it possible to clear these stats, in order to have them on a short
> sessions, along-side of the profiler for instance.
> Thanks
> Regards
>
Hello,
We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
sticked at 100% during few hours. The dbs are used by customers, we
didn't designed them, we just manage the system until middleware level
(SQL Server)
We would like to trouble this CPU problem. I use some tricks found on
the net, as the sp_who2, which gave me some details on the commands
run. I have a lot of sleeping process with AWAITING COMMAND; the
sp_who2 reported me also CPU and IO usage but I don't know which
units.
The output is at http://rafb.net/p/DWkMQO35.html
Can I have some pointers on how use th output of sp_who2 to track
performance problems
Thanks for your helpAre you on SQL 2000.
Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
approach I take is normally, to analyse these figures , ascertain whether
it's an IO or network problem . Then drill down to the db level
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com
<a href="http://links.10026.com/?link=uk/">http://www.itjobfeed.com">uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178200041.682518.327170@.n59g2000hsh.googlegroups.com...
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||And if you are using SQL2005 SP2, you would find the newly released dashboard
reports rather useful in finding queries that may be consuming excessive CPU.
Linchi
"tabarnak@.gmail.com" wrote:
> (I have only little knowledge in mssql)
> Hello,
> We have a 2 members MS SQL Cluster, which sometimes has its CPU usage
> sticked at 100% during few hours. The dbs are used by customers, we
> didn't designed them, we just manage the system until middleware level
> (SQL Server)
> We would like to trouble this CPU problem. I use some tricks found on
> the net, as the sp_who2, which gave me some details on the commands
> run. I have a lot of sleeping process with AWAITING COMMAND; the
> sp_who2 reported me also CPU and IO usage but I don't know which
> units.
> The output is at http://rafb.net/p/DWkMQO35.html
> Can I have some pointers on how use th output of sp_who2 to track
> performance problems
> Thanks for your help
>|||On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
> Are you on SQL 2000.
> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site. The
> approach I take is normally, to analyse these figures , ascertain whether
> it's an IO or network problem . Then drill down to the db level
> --
> Jack Vamvas
(being away for some days)
Hi Jack,
I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
CXPACKET, LATCH_EX and PAGEIOLATCH_SH
Am I right, could you give some explanatations and hints.
is it possible to clear these stats, in order to have them on a short
sessions, along-side of the profiler for instance.
Thanks
Regards|||I went to the link but got a 404
--
Jack Vamvas
___________________________________
Need an IT job? http://www.ITjobfeed.com/sql
<a href="http://links.10026.com/?link=">http://www.itjobfeed.com/sql"> uk it jobs</a>
"tabarnak@.gmail.com" <baptiste.millemathias@.gmail.com> wrote in message
news:1178703761.778779.133060@.e51g2000hsg.googlegroups.com...
> On 3 mai, 17:46, "Jack Vamvas" <DEL_TO_RE...@.del.com> wrote:
>> Are you on SQL 2000.
>> Try DBCC SQLPERF(WAITSTATS), and put the results up on your web site.
>> The
>> approach I take is normally, to analyse these figures , ascertain whether
>> it's an IO or network problem . Then drill down to the db level
>> --
>> Jack Vamvas
> (being away for some days)
> Hi Jack,
> I uploaded the output in http://rafb.net/p/6rXNqc96.html.
>>From what i'm seeing, the main causes of WAIT are RESOURCE_QUEUE,
> CXPACKET, LATCH_EX and PAGEIOLATCH_SH
> Am I right, could you give some explanatations and hints.
> is it possible to clear these stats, in order to have them on a short
> sessions, along-side of the profiler for instance.
> Thanks
> Regards
>
Subscribe to:
Posts (Atom)