Re: Performance problem
From: Andrew J. Kelly (sqlmvpnoooospam_at_shadhawk.com)
Date: 02/26/04
- Next message: Café CRM: "SP3a on Windows XP"
- Previous message: Andrew J. Kelly: "Re: Moving databases from SQL 7 to SQL 2000 - More Questions!"
- In reply to: Stephen Quist: "Performance problem"
- Next in thread: Stephen Quist: "Re: Performance problem"
- Reply: Stephen Quist: "Re: Performance problem"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 25 Feb 2004 20:36:38 -0500
Make sure you have AUTO CLOSE turned off in the databases and check to see
if you have ODBC tracing on.
-- Andrew J. Kelly SQL MVP "Stephen Quist" <quists@spamfree.msei-co.com> wrote in message news:OoJTPW$%23DHA.2592@TK2MSFTNGP10.phx.gbl... > Hey, > > I have SQL Server 2000 on my server. When I run the Enterprise > Manager from my workstation, the performance is absurdly slow. > By my stopwatch, it took 37 seconds just to open the connection > to the server and additional 2 minutes 45 seconds just to get the > list of databases, and that list is small (9)! Normal file access and > other activities related to the server seem to happen in a normal amount > of time. What could be causing such poor performance with SQL? > Both the server and the workstation are relatively fast (>=1Ghz) > machines with plenty of memory (512 MB). > > Steve > >
- Next message: Café CRM: "SP3a on Windows XP"
- Previous message: Andrew J. Kelly: "Re: Moving databases from SQL 7 to SQL 2000 - More Questions!"
- In reply to: Stephen Quist: "Performance problem"
- Next in thread: Stephen Quist: "Re: Performance problem"
- Reply: Stephen Quist: "Re: Performance problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
