Database Misbehaving - SQL Server Forums

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.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

Database Misbehaving

Author

Topic

boggyboy
Yak Posting Veteran

57 Posts

Posted - 2011-01-24 : 16:30:14

I'm a programmer trying to help a team stabilize their application. We have no DBA on the team and it seems cant get one for a couple weeks.

I'm told the transaction logs are filling up and the database is misbehaving. are there general steps we should take?

Nick W Saban

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-01-24 : 16:50:27

Backups should keep log in check.

View your error Log.

Here's a quick monitoring query, you can see what queries are running, how long for, blocking:

SELECT r.session_id, r.status, r.start_time, r.command, s.text, 
     SUBSTRING(text, (statement_start_offset/2) + 1,      
     ((CASE statement_end_offset           WHEN -1 THEN DATALENGTH(text)          ELSE statement_end_offset END
               - statement_start_offset)/2) + 1) AS statement_text,  
  blocking_session_ID, *
FROM 
  sys.dm_exec_requests r CROSS APPLY sys.dm_exec_sql_text(r.sql_handle) s
order by 
  R.Start_Time

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-01-24 : 17:12:59

Are you having performance issues? Tlog being full doesn't impact performance.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2011-01-24 : 17:43:08

For the transaction logs, please read through this - [url]http://www.sqlservercentral.com/articles/64582/[/url]

--
Gail Shaw
SQL Server MVP

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2011-01-25 : 03:43:23

What does "the database is misbehaving" actually mean? Please elaborate... And do you have a proper backup scheme in place? The tlog will usually not fill up if you are backing it up properly...unless you have some large import jobs or something between the tlog backups.

- Lumbago

My blog-> www.thefirstsql.com

boggyboy
Yak Posting Veteran

57 Posts

Posted - 2011-01-26 : 08:23:57

Thanks for these responses. I will try to get these implemented.

Nick W Saban

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources