Mar 15

SQL Server: Basics of Dynamic Management Views and DBCC Commands #Root #By Sayed Ahmed #MS SQL Server #SQL Server Reporting

Inspired By: Tuning Queries: SQl Server – http://salearningschool.com/displayArticle.php?table=Articles&articleID=1156&title=Tuning%20Queries:%20SQl%20Server

What are these? Dynamic Management Views, and DBCC Commands

Dynamic Management Views:

“Dynamic management views and functions return server state information that can be used to monitor the health of a server instance, diagnose problems, and tune performance.” From: http://msdn.microsoft.com/en-us/library/ms188754.aspx

DBCC Statements:

” DBCC statements act as Database Console Commands for SQL Server” From: http://msdn.microsoft.com/en-us/library/ms188796.aspx

Examples for Dynamic Management Views: http://www.mssqltips.com/sqlservertutorial/273/dynamic-management-views/

From: http://sitestree.com/?p=1435
Categories:Root, By Sayed Ahmed, MS SQL Server, SQL Server Reporting
Tags:
Post Data:2014-08-24 14:08:16
Shop Online: https://www.ShopForSoul.com/ (Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com In Bengali: http://Bangla.SaLearningSchool.com http://SitesTree.com 8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning) Shop Online: https://www.ShopForSoul.com/ Medium: https://medium.com/@SayedAhmedCanada