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