Home > IT Blogs > SQL Server with Mr. Denny/

SQL Server with Mr. Denny:

ERRORLOG

1
April 3, 2013  2:00 PM

How Many SQL Server ERRORLOG Files Do I Keep?



Posted by: Denny Cherry
ERRORLOG, SQL Server

When working with SQL Servers there are lots of settings that people like to tweak to make their SQL Server run smoother.  One setting that I really like tweaking is the number of ERRORLOG files that are kept.  By default SQL Server keeps the last 6 ERRORLOG files around deleting the last one...

  Bookmark and Share     1 Comment     RSS Feed     Email a friend

June 11, 2009  11:00 AM

Who’s been logging into my SQL Server?



Posted by: Denny Cherry
ERRORLOG, LOGIN, Security, SecurityFightClub, SQL Server 2000, SQL Server 2005, SQL Server 2008

Knowing who has been logging into your SQL Server is one of the key things to know about your SQL Server.  It lets you know quite a bit about who’s using your server, and about who’s been trying to break into your SQL Server, and most importantly if they have succeeded. Obviously you can...

  Bookmark and Share     2 Comments     RSS Feed     Email a friend

April 24, 2008  12:23 PM

My ERRORLOG shows some spids have an ‘s’ after them. What’s going on?



Posted by: Denny Cherry
ERRORLOG, sp_who3, SQL

That "s" is new in SQL Server 2005.  It means that the SPID is a system process.  For example my database is having a problem with tempdb running out of space for no reason.  When I look in the log I see that SPID 118s is the offending SPID.  When I watch SPID 118 using

  Bookmark and Share     0 Comments     RSS Feed     Email a friend

1