SQL Server 2005 Express running slow ?
-
Usual accounting program running database is SQL server 2005 express version, do not know why the last few days very slow when running reports, so no way for it to run faster? can specify the steps.
-
Usual accounting program running database is SQL server 2005 express version, do not know why the last few days very slow when running reports, so no way for it to run faster? can specify the steps.
Turn it off and turn it back on again. Seriously.
-
Usual accounting program running database is SQL server 2005 express version, do not know why the last few days very slow when running reports, so no way for it to run faster? can specify the steps.
If, after you have used the piebalds solution and checked the hard disks for space and your memory usage on the server, it is still a problem, turn on SQL profiler and run the reports, then analyse the action plan an determine if you have a problem with the queries. If after optimising your queries you still have an issue do some research into Parameter Sniffing, this is a long shot. If you still have a problem then hire a DBA consultant to look at your database!
Never underestimate the power of human stupidity RAH
-
Usual accounting program running database is SQL server 2005 express version, do not know why the last few days very slow when running reports, so no way for it to run faster? can specify the steps.
You could also try using the sys.dm_db_index_physical_stats[^] to look at the average fragmentation of your tables to identify any that have a higher level of fragmentation and then use REORGANIZE or REBUILD[^] to correct them.
Jack of all trades ~ Master of none.