Re: slow performance around 10 mins

From: izumi (test_at_test.com)
Date: 07/06/04 

Date: Tue, 6 Jul 2004 14:05:39 +0800

i use the command sp_who2
can see someone who consume the CPU as 660000

is it the problem?
"Thirumal" <treddym@yahoo.nospam.com> wrote in message
news:26dac01c4630e$8f3ae4b0$a401280a@phx.gbl...
> Tough call.
>
> 1]Check for any blocking - sp_who2 , sp_lock.
>
> 2]Use perfmon and check the disk qeue length, memory
> pages/sec, processor qeue lengh, buffer cache hit ratio.
>
> 3]You need to check if there are any long running queries
> or stored procedure recompiling by profiler. Look into
> Vyas site. He wrote two good articles on using profiler.
>
> Couple of good links I grabbed from Andy ball recently.
>
> Overview of General SQL Server Performance methodology
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;298475
>
> Online seminar on SQL2k Performance by a MS PSS guy who
> knows his stuff
> http://support.microsoft.com/default.aspx?scid=kb;en-
> us;838622
>
> HTH
> --
> Thirumal
> www.thirumal.com
>
> >-----Original Message-----
> >My sql server 2000 connected with one application
> software.
> >
> >But today it is quite slow around 10 mins. Slow in
> respond.
> >
> >How can i check who occpied the resources on sql server
> 2000
> >
> >
> >.
> >

Relevant Pages

  • slow performance around 10 mins
    ... pages/sec, processor qeue lengh, buffer cache hit ratio. ... He wrote two good articles on using profiler. ... Overview of General SQL Server Performance methodology ...
    (microsoft.public.sqlserver.server)
  • Re: slow performance around 10 mins
    ... > pages/sec, processor qeue lengh, buffer cache hit ratio. ... He wrote two good articles on using profiler. ... > Overview of General SQL Server Performance methodology ... >>How can i check who occpied the resources on sql server ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... SQL Server does not allow that - you can only add nullable ... > After you add a new column in Enterprise Manager, uncheck Allow Nulls, ... the ALTER TABLE statement above will pass to the SQL Server ... > 4) Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)
  • Re: Running profiler on busy 8-cpu Sql Server
    ... with SQL Server. ... Not only does the Profiler GUI's screen need to ... Server & places it on queues that the Profiler GUI picks up. ... / data columns & filters you define in a profiler trace, ...
    (microsoft.public.sqlserver.server)
  • Re: Problem altering table and adding a default
    ... ALTER TABLE dbo.Test_tbl ADD Notnull_col1 charNOT NULL ... SQL Server does not allow that - you can only add nullable columns. ... After you add a new column in Enterprise Manager, uncheck Allow Nulls, bind the uder- ... Start Profiler and perform a new trace. ...
    (microsoft.public.sqlserver.server)