GRK


Hi ,

I'm Using sql server 2000 which is stored in our server. and In our workstations we are using that one. we have a table in that database which will store Images on to that. so now my problem is the sql server is becoming very slow. I have to wait for long to open any instance or database or even a normal table. I have removed all the datab from the table in which I'm storing the images but still the server is not performing well.

can any one suggest how to increase the performance of the SQL Server

-regards

GRK





Re: sql server is very slow

Madhu K Nair


check the statistics, index fragmentation. In anycase, if you store image in Database , then the performance will hit. If you have removed all the images from the db and then also its slow then , it may be because of Fragmentation,statistcs are not updated and also indexes are outdated.

Run

(a) sp_updatestats

(b) DBCC DBREINDEX (its a offline process and it will lock the tables)

(c) check the space used by the database. you may need to shrink the db, incase there is drastic difference in actual data stored and the physical size of the file

Note : Store the image filename in the database instead of the image itself.

Refer these links too

http://www.sql-server-performance.com/forum/topic.asp TOPIC_ID=19594

http://www.sql-server-performance.com/forum/topic.asp TOPIC_ID=19595

Madhu







Re: sql server is very slow

jcesare

Make sure the "auto close" database option is off. There is a lot of overhead if you are the first user of a table/database. If you are using the other database occasionally and the "auto close" option is on, you'll have a ton of overhead.




Re: sql server is very slow

Sue Hoegemeier

And then the one other additional thing to check which can contribute to the slow downs you describe is to make sure ODBC tracing is turned off.

-Sue