SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags Auditing, SQL Trace Rss

   Items 1 to 4 of 4   

Server-Side Trace Pack

Loads temporary stored procs that assist in running and monitoring server-side tracing.  Read more...
By Greg Drake 2012/03/02 | Source: SQLServerCentral.com | Category: server side trace
Rating: (not yet rated) |  Discuss |   Briefcase | 1,039 reads

Auto Generate an Hourly SQL Server Profiler Trace File

I would like the option on some servers of having a profiler trace running 24x7 in the background. I could then access and read these trace files to investigate issues after the fact - much like the default trace that came out with SQL 2005.   Read more...
By Additional Articles 2009/09/29 | Source: MSSQLTips.com | Category: sql trace
Rating:  Rate this |   Briefcase | 3,959 reads

SQL Server Audit: Magic without a Wizard

In SQL Server 2008, Microsoft introduced SQL Server Audit. This is much better than anything we had before, and is likely to meet the needs of all but the largest, or most highly-regulated industries. SQL Server 2008 Enterprise Edition includes all of the features, whereas SQL Server 2008 Standard Edition only provides a subset. What is most attractive about it, is that it is easy to administer, as Thomas LaRock explains.  Read more...
By Additional Articles 2009/05/12 | Source: SimpleTalk | Category: auditing
Rating: (not yet rated)  Rate this |   Briefcase | 2,624 reads

Default Trace Load of All 5 Files

The default trace keeps the last 20 meg of info, and a max of 5 files...This loads all 5 files into a table so it can be reviewed.  Read more...
By Lowell Izaguirre 2009/02/25 | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 1,197 reads
   Items 1 to 4 of 4   
default trace (2)    
monitoring (2)    
production support (1)    
profiler (1)    
server side trace (1)    
sql server 2005 (1)    
sql server 2008 (1)    
trace (1)