Click here to Skip to main content
15,436,916 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
Hello,

We are having a data base with around 600,000 rows running on SQL server 2008. We are running a LAN application, bought recently from market of very high speed server. But some times SQL Server is getting very slow. For ex:- on Monday morning when we return to work [I assue that sql server is idle for about 48 hours... and may be services are down or some thing...]. If we restart the SQL server Service from control panel again it is working as it should. Can anybody help me in this regard????

This is only a database server, except this we are nothing running on this machine.

Configuration :- Multi core processor
Ram : - 32 GB

LAN Card :- 10/1000

LAN :- Optical fibre

chowdary.
Posted
Comments
[no name] 11-Oct-12 19:59pm    
Did you profile the server to see what is causing the "slow down"?
Mehdi Gholam 12-Oct-12 2:27am    
You really have to quantify "slow" between the two states. 600k rows is nothing for a 32gb sql server box.
Herman<T>.Instance 12-Oct-12 4:46am    
true,but wthat are states if the indexes? does he use non clustered or clustered indexes, and so on After a reboot indexes are reorganised.
Charles Shob 14-Oct-12 23:12pm     CRLF
digimanus, So what would you sugget??? Clustedred or non clustered index???? Regards...
Herman<T>.Instance 15-Oct-12 4:35am    
no non clustered indexes. And the clustered index is your primary key. So maybe you have to add fields or change your primary key. (don't know you db diagram)

1 solution

Please optimize your database, stored procedure because such configuration runs good for just only 6000000 rows.. as well can u use profiler to check where exactly it takes time and paste those queries here..

As well as u can use Transaction Isolation Level OR Lock Hints to improve performance.

Regards,
Keep helping nature..
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month


CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900