April 24, 2002 at 5:27 pm
All,
I'm having a strange problem with my production server. The server is running on SQL2k-- SP2 on WIN2k-- SP2 Compaq DL 760's (8 way processors).
The database size is 16GB. We run Full backup every night @ 9PM and tlog backup every hour between 11:30PM - 8:30PM.
Now the question is.... Daily after every full backup the first tlog backup is very huge almost the 16 GB and the next subsquent tlog backup are few megs.
There is basically no user transactions or any Jobs running between 9PM to 11:30PM. How come my first tlog backup grows very huge??
Thus we have a space issues on the server.
Please help !!
Thanks
Mike
April 24, 2002 at 5:43 pm
What is the size of the TL at 9pm? And if is small then something is happening in those hours, you may want to set up Profiler to catch what it is.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 5:49 pm
What is the size of the TL at 9pm? And if is small then something is happening in those hours, you may want to set up Profiler to catch what it is.
The size og TL is 7MB.
April 24, 2002 at 6:02 pm
Then something is happening transaction wise. If you know of nothing then start Profiler to catch transactions in the database to a file or table or just leave open. As long as you catch the event, text, username, app name and time you should be able to find out what.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 6:15 pm
Well this is a production environment. I know SQL profiler EATS up memory. Is there any other way??
April 24, 2002 at 6:17 pm
I mean any specfic event to be captured??
Thanx
April 24, 2002 at 6:45 pm
Not really unless you want to invest in a tool like Log Explorer which can read the actual transaction log and is very usefull. Otherwise, I would look at completed events for TSQL and Stored Procedures and only on the DB in question.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
April 24, 2002 at 6:55 pm
Are you running an index rebuild or shrinking the db? Both generate huge numbers of transactions.
Andy
April 29, 2002 at 7:11 pm
Yes we are running DBCC DBREINDEX daily during that time as part os our Maintenance
Viewing 9 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply