• ahperez (7/8/2013)


    Please define what you mean by "slow". What are the exact symptoms? What is the db doing that it doesn't normally do? What troubleshooting have you done so far?

    Agree with this statement... What is running slow? Is it a insert? A certain stored procedure? First step is to find out what is running slow then if you don't know what sql is being run I would run the sql profiler and see what statements are being run and which ones are slow... Then look at the code and see what can be done to make it run faster. May need to look at the server also... Is it a vm, does it have slow disks, low memory, when was sql last restarted. Lots of variables to look at with out more information...