Re: Sql server is getting too slow

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Peter Yeoh (nospam_at_nospam.com)
Date: 06/25/04 

Date: Fri, 25 Jun 2004 08:58:06 +0800

You need to monitor what is actually happening when the database performance
drops e.g. is it as a result of writers blocking readers, disk I/O increases
at that time, CPU usage is high for whatever reason etc, and then work on
the cause of the slowdown. You can get most of those information using the
SQL Server counters in Wndows Performance Monitor.

Peter Yeoh
http://www.yohz.com
Need smaller SQL2K backup files? Try MiniSQLBackup

"Rocky" <rockyt@signing-services.com> wrote in message
news:20052ab9.0406241145.6d79f895@posting.google.com...
> Hello There!
>
> Can someone help me to improve the performance of my sql server 2000?
> Here is the problem I'm having. When we roll out the database to the
> production, we did a lot of optimization just to improve performance.
> We Re-index our tables by using "DBCC REINDEX", But, still once in a
> while, the database will get too slow.
>
> Any other techniques?
>
> Thanks.

Relevant Pages

  • RE: Problem with Database Colors
    ... to this and even reds will be washed out. ... If you still can't see red on the monitor, check to ensure that the video ... See http://www.QBuilt.com for all your database needs. ...
    (microsoft.public.access.forms)
  • Re: .mdf file does not grow.
    ... monitor to activity on the database in order to estimate how soon we'll ... database file with a particular size and SQL Server allocates space within ... You create a partition on a disk and the OS allocates ... DBA's monitor the free space and manually increase the database size when it ...
    (microsoft.public.sqlserver.msde)
  • RE: Looking for help against Chinese Hacking Team
    ... Enable debugging/tracing of queries (or whatever your database supports) ... in your database and monitor them ... hour (it is not an average rate since high-end rates go up to $600 an hour). ... Security Trends Report from Cenzic ...
    (Pen-Test)
  • Re: Security Issue
    ... the only type of activity that you can monitor AFTER the fact is data ... transaction log with 3rd party tools like Lumigent's Log Explorer ... BUT - I'm not sure of the versions they support prior to SQL Server 2000... ... > on that particular database. ...
    (microsoft.public.sqlserver.security)
  • Re: oracle socket creation
    ... Thank you men for the insight. ... DB has gone down and it's listener stays up. ... Since I have about 45 DB's to monitor I figured why not ... > As for using an arbitary query for finding out the database status, ...
    (comp.lang.perl.misc)