READ Data from default Trace
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2019-05-03 (first published: 2015-04-08)
1,172 reads
READ Data from default Trace to know when the objects are altered. If no database name is provided, it will run through all the databases.
2019-05-03 (first published: 2015-04-08)
1,172 reads
Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.
2013-05-23
5,897 reads
Since the introduction of SQL Server 2005, there is a simple lightweight trace that is left running by default on every SQL Server. This provides some very valuable information for the DBA about the running server, but it isn't well-documented. Feodor Georgiev reveals many of the secrets of this facility and shows how to get reports from it.
2011-03-28
3,896 reads
Learn how to use the SQL Trace subsystem in SQL Server to audit your instances. This series will examine the basics of SQL Trace and teach you how to set up, schedule, and manage traces and the data generated.
2019-03-26 (first published: 2011-02-01)
2,635 reads
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.
2009-09-29
3,975 reads
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.
2009-02-25 (first published: 2009-02-07)
1,227 reads
2008-12-26
2,975 reads
2008-12-08
2,464 reads
This is part of a series of new job blog posts. You can find...
By Will Assaf
SQL Server 2022 Administration Inside Out is now available for pre-order from Microsoft Press. This...
Back in December 2019, I started presenting my session on mental health with lots...
I am having Below Table i want to get Result as shown in the...
what I want is to apply some filter patterns to search the data. For...
Hi All, Using Tsql query I want to know currently running sql agent jobs...