| Author |
Topic |
|
dre3
Starting Member
14 Posts |
 Posted - 2008-06-16 : 12:28:25
|
| Does anyone have any experience with a server slowing down over time to the point that it must be rebooted? This occurs over a time frame of from a few days to as long as a week. The server has a single Xeon 3.6 processor and 8 GB of ram. It executes production SQL scripts against databases contained on the server as well as a data warehouse stored on an AS400 server.After rebooting, all jobs seem to execute in a reasonable time frame, according to their size and scope. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-16 : 14:03:45
|
| Is your service packs and hot fixes upto date? What exactly error do you get in event log ? |
 |
|
|
dre3
Starting Member
14 Posts |
Posted - 2008-06-18 : 10:28:18
|
| It appears that all service packs are installed.SELECT @@VERSION gives the following response - Microsoft SQL Server 2005 Version 9.00.3042.00 Enterprise Edition on Windows 5.2 Build 3790 Service Pack 2. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-06-18 : 11:59:20
|
| You didn't mention whether it is 64-bit or 32-bit? |
|
|
|
dre3
Starting Member
14 Posts |
Posted - 2008-06-18 : 12:26:23
|
| The XEON processors are 32 bit dual pipeline. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-06-18 : 12:47:16
|
| Although you've got the latest service pack installed, you don't have the latest build installed. We are over 3200 now. Try installing the latest GDR.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-06-18 : 22:44:25
|
| Is it dedicated sql server? How did you set memory for sql? |
|
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-06-19 : 07:52:34
|
| When the server runs slow, what do you see in Activity Monitor on SQL Server? Do you have a ton of connections? Maybe there is something wrong with the Distributed Transactions Coordinator (DTC) or maybe you even have some infinite loops on one of your queries for all I know. Do you use explicit transactions?- Lumbago |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-06-19 : 11:41:45
|
| Check with Locking or Blocking on the Process. Also Check for DBCC Opentran for any opened Transactions.ManojMCP, MCTS |
|
|
|
|
Server slow down