Re: SQL Server slows down after 1-2 hours

From: Albrecht Reimann (nospam.reimann_at_tdcspace.dk)
Date: 02/19/05 

Date: Sat, 19 Feb 2005 15:38:04 +0100

I think the profiler was the "bad guy" in my setup. It ran continuously in
order to get some idea of which queries are heavy and which not. Since i
stopped the profiler, memory usage seems to grow to a certain level and then
remain at this level (filling up the cache ?).

I found a simple and helpfull articel on performance tuning:
http://www.sql-server-performance.com/articles_performance.asp

"Yogish" <yogishkamathg@icqmail.com> skrev i en meddelelse
news:DB9B600A-D42F-4CC3-BCFA-54BF0E890E3F@microsoft.com...
> Hi,
>
> What version of SQL Server are you running? IMO, if it slowing down
> everytime you re-start the service, there must be something which is
filling
> up the cache.... you can run DBCC MEMUSAGE (run this in SQL 2K only) and
DBCC
> PROCCACHE to know the data and procedures in the memory. Also you may want
to
> run SQL profiler to track down the heavy queries which is causing high
CPU.
>
> ---------
> Thanks
> Yogish

Relevant Pages

  • Re: Monitoring Impact of a User in SQL Server
    ... At least it will be read only but they can still issue any queries they want. ... Profiler or Trace will allow you to see what each connection is doing. ... Andrew J. Kelly SQL MVP ... I didnt actually realise SQL Server had ...
    (microsoft.public.sqlserver.tools)
  • Re: Slow database
    ... Can you run a profiler and identify the queries / Procedures causing the ... Check the Queries are written in optimized way. ... If you have mutiple disk controllers in the server, ...
    (microsoft.public.sqlserver.tools)
  • 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: 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)