Tag: dbcc

SQL Server

Undocumented Miscellaneous SQL Server 2014 DBCC Commands

Undocumented Miscellaneous SQL Server 2014 DBCC Commands In this article, you can find the description of some useful undocumented miscellaneous DBCC commands, and find out how you can use these commands in SQL Server 2014. 1. DBCC COLLECTSTATS This command can be used to turn on/off cache statistics. Syntax: DBCC COLLECTSTATS (‘on’ | ‘off’) This example turns on cache statistics: […]

Pro Members SQL Server Standard Members

Undocumented Maintenance SQL Server 2014 DBCC Commands

Undocumented Maintenance SQL Server 2014 DBCC Commands In this article, you can find the description of some useful undocumented maintenance DBCC commands, and find out how you can use these commands in SQL Server 2014 for administering and maintenance tasks. 1. DBCC addinstance This DBCC command can be used to add an object instance to track in Performance Monitor. Syntax:...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
SQL Server

Some useful SQL Server 2014 trace flags

Some useful SQL Server 2014 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2014: – global trace […]

Pro Members SQL Server Standard Members

Some useful SQL Server 2014 trace flags

Some useful SQL Server 2014 trace flags Trace flags are used to temporarily set specific server characteristics or to switch off a particular behavior. You can set trace flags by using the DBCC TRACEON command or by using the -T option with the sqlservr command-line executable. There are 2 types of trace flags in SQL Server 2014: – global trace...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
SQL Server

Tips for using SQL Server 2014 Database Console Commands

Tips for using SQL Server 2014 Database Console Commands Run DBCC commands during periods of low database access. Because DBCC commands usually are very resource effective, try to schedule them during CPU idle time and slow production periods. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains […]

Pro Members SQL Server Standard Members

Tips for using SQL Server 2014 Database Console Commands

Tips for using SQL Server 2014 Database Console Commands Run DBCC commands during periods of low database access. Because DBCC commands usually are very resource effective, try to schedule them during CPU idle time and slow production periods. Use DBCC CHECKFILEGROUP instead of DBCC CHECKDB, if you need to check only specified filegroup, not entire database. If your database contains...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

SQL Server 2012 DBCC Optimization Tips (Part 2)

SQL Server 2012 DBCC Optimization Tips (Part 2) Consider using the NOINDEX option with DBCC CHECKDB and DBCC CHECKTABLE command. This option specifies that intensive checks of nonclustered indexes for user tables should not be performed. Using the NOINDEX option decreases the execution time and should be used whenever possible. If you need to run DBCC CHECKDB or DBCC CHECKFILEGROUP...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here
Pro Members SQL Server Standard Members

SQL Server 2012 DBCC Optimization Tips (Part 1)

SQL Server 2012 DBCC Optimization Tips (Part 1) Before executing DBCC CHECKDB command, run this command with the ESTIMATEONLY option to estimate the tempdb space needed for CHECKALLOC and CHECKTABLE. So, you can calculate the tempdb database size and run the DBCC CHECKDB command without performance degradation. When this option is used, the actual database check is not performed. Use...

This content is for Pro, Pro Member, Pro Member Annual - Fall Sale, Pro Member Monthly - Fall Sale, Standard, Standard Member, Standard Member Annual - Fall Sale, and Standard Member Monthly - Fall Sale members only.
Register
Already a member? Log in here