my sql server is working slow what should i do?

Question

my sql server is working very slow.when i start it works fine and after 2 hours r so its getting hang out.and what i noticed is its taking 99% of the cpu usage.please advice

Answer 1

You need to ask yourself a few questions:

1) How big is the table youre trying to query against?
2) Do you have an index in your query?
3) Are you using a loop?

If you have a huge table and you are using a loop to query against that table and you dont have an index, then your query will hang because its taking too long to bring back results.

Answer 2

hit ctrl-shift-escape
that pulls up the tast manager
then click on the processes tab
look down the list of things youll see to the left the name of the process then to the right of that youll see a column for cpu
look for the process that has the highest cpu #
then add the details to your question with that info and ill try to help more

Answer 3

Rather than blaming the database aspects of the program, perhaps your memory and CPU may be underpowered.

SQL Server is a memory and CPU hog and does not like being underpowered.