Re: Slow database

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 05/04/04 

Date: Tue, 4 May 2004 11:53:13 +0530

Hi,

Can you run a profiler and identify the queries / Procedures causing the
bottle neck. You can save the profiler output as an workload file
and use that as in an input to Index tuning wizard and check the Indexes.

As well as indetify the procedures running for longer time usingf Profiler
an do:-

1. Execute in Query analyzer with Execution plan enabled. If you have any
table scan create necessory indexes
2. Check the Queries are written in optimized way.

Note:

If you have mutiple disk controllers in the server, create the file groups
spanned across mutiple controllers. This will reduce the DISK I/O, which
inturn icreases the performance.

Thanks
Hari
MCDBA

"dimitris" <anonymous@discussions.microsoft.com> wrote in message
news:4F4C2D57-3E0F-4F4B-A956-DF43DB6CBC93@microsoft.com...
> Hi,
> My ERP database stands on a SQL2000 sp3 server with Windows 2000 SP4.
> Pleanty of disk space and 3 Gb of memory. The database itself is only 4
Gbincluding the log file. At the end of the month about 50 employees prepare
bills and run reports, and the database gets really slow!!!! The rest of the
month everything is fine.
> Any ideas how to fix that?

Relevant Pages

  • Re: Bad performance of HTTPServletResponse at Tomcat
    ... My servlet performs database queries and returns the answer to client. ... execution time of DB queries doesn't change, and the time of writting ... To my mind I need to tune Tomcat. ... I would add a picture from the profiler that shows this problem, ...
    (comp.lang.java.programmer)
  • Re: SQL Server slows down after 1-2 hours
    ... I think the profiler was the "bad guy" in my setup. ... order to get some idea of which queries are heavy and which not. ... remain at this level (filling up the cache ?). ... > What version of SQL Server are you running? ...
    (microsoft.public.sqlserver.server)
  • RE: High CPU Usage
    ... Run profiler and see what queries are taking the longest and which ones are ... > This SQL is used as a reporting SQL Server and the ... What else I can do to resolve this sitation. ...
    (microsoft.public.sqlserver.programming)
  • URGENT!!! Locking timouts
    ... You can use the profiler but modify it to look at queries ... In the meanwhile try changing your timeout in SQL Server ...
    (microsoft.public.sqlserver.server)
Loading