Database

View All Threads First Prev Next

SQL Server 2005 Express running slow ? Member 245846728-Jan-13 15:56 Member 2458467 28-Jan-13 15:56  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. Re: SQL Server 2005 Express running slow ? PIEBALDconsult28-Jan-13 16:11 PIEBALDconsult 28-Jan-13 16:11  Turn it off and turn it back on again. Seriously. Re: SQL Server 2005 Express running slow ? Mycroft Holmes28-Jan-13 17:02 Mycroft Holmes 28-Jan-13 17:02  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 Re: SQL Server 2005 Express running slow ? JOAT-MON29-Jan-13 11:09 JOAT-MON 29-Jan-13 11:09  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.

Last Visit: 31-Dec-99 18:00     Last Update: 26-Apr-24 7:37 Refresh 1

General    News    Suggestion    Question    Bug    Answer    Joke    Praise    Rant    Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.