|
Home > Archive > MS SQL Server > May 2005 > Sql server slow down
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Sql server slow down
|
|
|
| Hi All,
I have a Windows 2000 machine running sql server 2000 at office.
Recently, my sql server has become painfully slow. To give an idea, entering
Query Analyzer takes 1 min just to establish a connection with the database.
Choosing a database from the drop down takes a long time for the combo to
display all the databases. Expanding the database node in Enterprise Manager
takes ages for it to expand.
I have scanned my pc for any virus but didnt find any. I have removed
sql server and installed a couple of times but to no avail. Can anyone
please suggest me a solution apart from formatting my pc!
Many Thanks
| |
|
| Just found out it was because I started odbc tracing. I stopped it and sql
server is normal.
"Ayaz" <r_ayaz1@yahoo.com> wrote in message
news:eA8g9FuYFHA.1092@tk2msftngp13.phx.gbl...
> Hi All,
>
> I have a Windows 2000 machine running sql server 2000 at office.
> Recently, my sql server has become painfully slow. To give an idea,
> entering
> Query Analyzer takes 1 min just to establish a connection with the
> database.
> Choosing a database from the drop down takes a long time for the combo to
> display all the databases. Expanding the database node in Enterprise
> Manager
> takes ages for it to expand.
>
> I have scanned my pc for any virus but didnt find any. I have
> removed
> sql server and installed a couple of times but to no avail. Can anyone
> please suggest me a solution apart from formatting my pc!
>
> Many Thanks
>
>
>
| |
| John Bell 2005-05-28, 8:23 pm |
| Hi
This does have serious impact as you have found! Don't forget to delete the
log file and free up the space!
John
"Ayaz" <r_ayaz1@yahoo.com> wrote in message
news:%236xuoXuYFHA.1412@TK2MSFTNGP12.phx.gbl...
> Just found out it was because I started odbc tracing. I stopped it and sql
> server is normal.
>
>
> "Ayaz" <r_ayaz1@yahoo.com> wrote in message
> news:eA8g9FuYFHA.1092@tk2msftngp13.phx.gbl...
>
>
|
|
|
|
|