What is a Trace frag? Where do we use it? - Sql server

What is a Trace frag? Where do we use it?

Temporary setting of specific server characteristics is done by trace tags. DBCC TRACEON is the command to set the trace flags. Once activated, trace flag will be in effect until the server is restarted. Trace frags are frequently used for diagnosing performance issues.

For example, the trace flag 3205 is used for disabling hard compression for tape drives, when an instance of SQL Server starts.
Describe how to use Linked Server - Sql server
Linked Server - MS SQL Server supports the connection to different OLE DB on an ad hoc basis. This persistent connection is referred as Linked Server.......
Explain how to send email from database - Sql server
Send email from database - SQL Server has a feature for sending mail. Stored procedures can also be used for sending mail on demand. With SQL Server 2005, MAPI client is not needed for sending mails.......
How to make remote connection in database - Sql server
How to make remote connection in database - The following is the process to make a remote connection in database: Use SQL Server Surface Area Configuration Tool for enabling the remote connection in database........
Post your comment

Related Content

Follow us

▲