Last post Feb 03, 2015 01:07 AM by cnranasinghe
Jan 27, 2015 02:25 PM|Arial12|LINK
I have this SQL server 2008 database server. database has 1 million+ records. there are times, it takes so long to run queries and database connection just drops.
Onlyway i am able to pull up database On is by restarting SQL service agent service. but I would like to know what is it that is causing this database to crash or slow response to bring query result.
I am not a DBA, can someone suggest how to run diagnostic tests my database? some simple tests that can help me.
i can write basic SQL queries fine.
Thanks for your help,
Jan 27, 2015 02:28 PM|PatriceSc|LINK
Could it be that you are missing the proper index? See
http://en.wikipedia.org/wiki/Database_index Do you know which query is causing the issue?
Jan 29, 2015 03:47 AM|Edwin Guru Singh|LINK
As per your case, I have been shared my ideas below :
1. Make sure that your hard disk memory is enough.
2. You could really need to examine the Query Plan for the poorly performing code.
3. Paste your query in a query Window and Hit CTRL+L. This should pretty much tell you what it doesn't like.
4. If you use the SSMS 2008 IDE connected to your SQL2005 databases and run the query plan,.It should also give you a recommendation on any missing indexes that would help your query.
5.Based on limited information provided without seeing structures, indexes, etc. of the tables involved
Feb 02, 2015 05:18 PM|Arial12|LINK
Thank you Edwin and PatriceSc.
Slowness happens on just about any query. But i know one perticular Primary key used by call. Is it possible to re-index the primary key or commonly used data field?
Edwin, i will try your suggestion.
Thank you once again.
Feb 03, 2015 01:07 AM|cnranasinghe|LINK
Check followings, There are known OS problems, make sure they are relevant to your infrastructure,
Above URLs are extracted below blog post