Access to SQL Server 2k database is slow

My SQL server was just upgraded from 7.0 to 2000. It was having memory leak
problems before, so it was upgrade to 2000 by the agency that over sees our
databases. Now the access time to the database is pretty slow when trying to
pull up information. Our custom client software loads fine and connects to
the database, but we when we do a search or try to open a particular case
(we are a court) from the database, it takes almost 30 seconds before any
information comes up. No error messages are returned. It is just a slow
response time. Sql server 2k is installed on a w2k server and the clients
are running XP pro, with 100mb/full duplex on a switch. I am not familiar
enough with sql server so I wouldn't exactly what to look for or what kind
of commands to run for running the Profiler or Query Analzyer.
I would appreciate any help anybody could provide. In case your wondering,
the guy who did the upgrade decided to take 3 days off after doing this on
the weekend, don't ask me why? I am the tech person for the agency, just no
familiar with sql server. Again, thanks for any help or advice.Make sure the autoclose database option is not set to on. You can check this
out in enterprise manager, right click on your database and then go to
options. If this is not your problem, I think you're going to have to run
your query manuaaly from query analyzer to see if the problem is within sql
server or outside.
Carlos E. Rojas
SQL Server MVP
Co-Author SQL Server 2000 programming by Example
"Vegeta" <vegeta@.whocares.com> wrote in message
news:%23BhI6Y2CEHA.3408@.tk2msftngp13.phx.gbl...
> My SQL server was just upgraded from 7.0 to 2000. It was having memory
leak
> problems before, so it was upgrade to 2000 by the agency that over sees
our
> databases. Now the access time to the database is pretty slow when trying
to
> pull up information. Our custom client software loads fine and connects to
> the database, but we when we do a search or try to open a particular case
> (we are a court) from the database, it takes almost 30 seconds before any
> information comes up. No error messages are returned. It is just a slow
> response time. Sql server 2k is installed on a w2k server and the clients
> are running XP pro, with 100mb/full duplex on a switch. I am not familiar
> enough with sql server so I wouldn't exactly what to look for or what kind
> of commands to run for running the Profiler or Query Analzyer.
> I would appreciate any help anybody could provide. In case your wondering,
> the guy who did the upgrade decided to take 3 days off after doing this on
> the weekend, don't ask me why? I am the tech person for the agency, just
no
> familiar with sql server. Again, thanks for any help or advice.
>|||The autoclose database option was not set to on. I also just saw that sql
server
2k had no service packs installed. I will be backing up my database and
installing
sql 2k SP3a. Maybe this could help it some.
Thanks for you response.
"Carlos Eduardo Rojas" <carloser@.mindspring.com> wrote in message
news:%23tdVxG4CEHA.3804@.TK2MSFTNGP09.phx.gbl...
> Make sure the autoclose database option is not set to on. You can check
this
> out in enterprise manager, right click on your database and then go to
> options. If this is not your problem, I think you're going to have to run
> your query manuaaly from query analyzer to see if the problem is within
sql
> server or outside.
> --
> Carlos E. Rojas
> SQL Server MVP
> Co-Author SQL Server 2000 programming by Example
>
> "Vegeta" <vegeta@.whocares.com> wrote in message
> news:%23BhI6Y2CEHA.3408@.tk2msftngp13.phx.gbl...
> leak
> our
trying
> to
to
case
any
clients
familiar
kind
wondering,
on
> no
>|||On 2004-03-16, Vegeta <vegeta@.whocares.com> wrote:
> The autoclose database option was not set to on. I also just saw that sql
> server
> 2k had no service packs installed. I will be backing up my database and
> installing
> sql 2k SP3a. Maybe this could help it some.
>
Try updating MDAC on the client machines. I had the same problems on some
machines at my company, though we're running Win2k on most of clients.
Mike
--
"I can do it quick. I can do it cheap. I can do it well. Pick any two."
Mario Splivalo
msplival@.jagor.srce.hr