Re: slow performance around 10 mins
From: izumi (test_at_test.com)
Date: 07/06/04
- Next message: Hubert Mayr: "sqlserver 2000 new subnet mask login problem"
- Previous message: Kalen Delaney: "Re: Roles & Users"
- In reply to: Thirumal: "slow performance around 10 mins"
- Messages sorted by: [ date ] [ thread ]
Date: Tue, 6 Jul 2004 14:16:51 +0800
in sp_lock command
461 rows returned
"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
> >
> >
> >.
> >
- Next message: Hubert Mayr: "sqlserver 2000 new subnet mask login problem"
- Previous message: Kalen Delaney: "Re: Roles & Users"
- In reply to: Thirumal: "slow performance around 10 mins"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
