Re: Performance Degradation on SQL 2000
From: Tibor Karaszi (tibor_please.no.email_karaszi_at_hotmail.nomail.com)
Date: 03/15/04
- Next message: Sue Hoegemeier: "Re: Can DTS read a file as one big blob?"
- Previous message: greg: "while dbcc shrinkfile runs..."
- In reply to: Deborah Bohannon: "Re: Performance Degradation on SQL 2000"
- Next in thread: Cqlboy: "RE: Performance Degradation on SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 15 Mar 2004 17:06:37 +0100
I'd probably start with Perf mon, Process, and check memory for each
process. It might be a good idea to see if there are any particular
recommendations at www.sql-server-performance.com first.
-- Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp "Deborah Bohannon" <dbohannon@nationalDONOTSENDHEREcareanetwork.com> wrote in message news:OF$d5NqCEHA.3568@tk2msftngp13.phx.gbl... > I will check with our sys admin to see which counters he is still > monitoring. What should I be looking for in checking for memory leaks? Is > there a defined set of criteria? > > Thanks, > Deborah > > > "Tibor Karaszi" <tibor_please.no.email_karaszi@hotmail.nomail.com> wrote in > message news:uhcY%232OCEHA.1140@TK2MSFTNGP10.phx.gbl... > > No, you shouldn't have to reboot an SQL Server machine. I'd start checking > > for memory leaks. Remember that any process or driver can leak memory. > > > > -- > > Tibor Karaszi, SQL Server MVP > > http://www.karaszi.com/sqlserver/default.asp > > > > > > "Deborah Bohannon" <dbohannon@nationalDONOTSENDHEREcareanetwork.com> wrote > > in message news:%23TWLkLFCEHA.2796@TK2MSFTNGP09.phx.gbl... > > > Hello all, > > > > > > I am wondering why performance dramatically decreases on our SQL Server > > 2000 > > > the longer we go from rebooting the server. > > > > > > We are using an ACCESS 2000 custom application as the front end to our > SQL > > > database. (We're in the process of moving that app to .NET). Our > server > > is > > > running on Windows 2000 Advanced Server, has 2 processors, 4 GB memory, > > RAID > > > 5 array, plenty of space on the drives. The database size is only > > > approximately 7GB, Full Recovery model with appropriate backups. > > > > > > Still, after we reboot the server, everything is running fast again... > for > > a > > > few days. We had multiple complaints from users in the last few days > > about > > > performance slowing down and rebooted the server. It had only been 19 > > days > > > from the last reboot. > > > > > > I've been running profiler and perf mon traces and have spent the last > > month > > > doing much optimization, which did significantly help. Yet, we still > have > > > this degradation. > > > > > > Should the server have to be rebooted frequently? Right now we've > decided > > > to schedule it for once a week, but it just seems that we should not > have > > to > > > be doing it that often. > > > > > > Any ideas are most welcome. > > > > > > Thanks, > > > Deborah > > > > > > > > > > > >
- Next message: Sue Hoegemeier: "Re: Can DTS read a file as one big blob?"
- Previous message: greg: "while dbcc shrinkfile runs..."
- In reply to: Deborah Bohannon: "Re: Performance Degradation on SQL 2000"
- Next in thread: Cqlboy: "RE: Performance Degradation on SQL 2000"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
