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 - 2004-06-09 : 07:15:58
|
| Helen writes "I am running:Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3) My sql server 'hangs' once in a while, and so that I have to reboot it. When I look at the server log, among other things I see that "164 transactions rolled forward in database 'db_shell' (10)." What really bothers me is that db_shell is not a real database. It is just a shell, whith all the tables and no data. There is absolutely, positivly no user activity in this db. There are other databases on the server that are rarely used, and the server log shows tens and hunderds of transactions being rolled forward. And the numbers are growing with each reboot. At the same time, the real production database only shows a couple of transactions being rolled.My question is - what could be causing these open transactions on a dormant database? What tools should I use to monitor it?THanks a lot in advance for your help.Helen" |
|
|
rihardh
Constraint Violating Yak Guru
307 Posts |
Posted - 2004-06-09 : 08:34:10
|
| Hmmm... Seems like somebody or something is playing around with your HW. A simple way to find out who, is to look at the Process info in the Current activity tree in EM (or sp_who in QA). An effective way to find out and monitor the traffic on your SQL server would be the usage of SQL profiler. |
 |
|
|
mcrowley
Aged Yak Warrior
771 Posts |
Posted - 2004-06-09 : 13:40:07
|
| I think these are caused by backups. In short, when you do a full backup of a database, some of the page headers have to be updated, so the next differential backup (which, yes, may never happen) will know where to pick up. |
|
|
|
|
|
|
|
|
lots of open transactions