Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-12-13 : 08:11:58
|
| Vipins writes "Hello SQL Team We are using SQL server 2000 as the back end for four .NET desktop applications. Also the same SQL server is used to store the BizTalk databases too. The total number of users accessing the four desktop applications is nearly 100. The issue is that we might end up in restarting the SQL server periodically since the .NET application becomes too slow. So we have created a scheduled task to restart the SQL server periodically. So can you tell me why it is happening? Is there any way to avoid restarting the SQL server?System Details :- The database runs on Microsoft(R) Windows(R) Server 2003, Standard Edition (Service pack 1.0) system of Intel(R) Xeon(TM) CPU 3.00GHz processor, 4GB of Ram. The total hard disk space is 341.45 GB and out of which 80.62 GB is free.Other Details:- We have nearly 7 tables in the database and indexes are created for all the tables. We have a transaction table that stores nearly 15,000 records everyday. I appreciate your help and thanks a lot for your valuable time. Thanks and RegardsVipins" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2006-12-13 : 09:22:33
|
| Could be a number of things.Data changing so the query plans are out of data.Something taking memory and not releasing it so everything gets starved.A process that does something wromg periodically - like using up cpu time, repeating table scans, hogging memory, ...Something is blocking - maybe due to out of date statistics.Have a look at what's using memory and what is accessing the database.Check the disk ioPut this on the server and run it to see active database processeshttp://www.nigelrivett.net/SQLAdmin/sp_nrInfo.html==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
Issue of Re-Starting SQL Server