Humble Request
CheckDB is not an easy thing to run without taking maintenance window from app team.
However, being humble by taking permission and let it run atleast once a week as this is necessary.
SQL Server वादे पक्के वादे!
Best Regards
T. Amit Vaid S.
https://amit-sqldbasupport.blogspot.com/2023/05/ms-sql-server-freelancing-builds.html?m=1
ReplyDeleteALL_ERRORMSGS
ReplyDeleteDisplays all reported errors per object. All error messages are displayed by default. Specifying or omitting this option has no effect. Error messages are sorted by object ID, except for those messages generated from tempdb database.
Lock:Deadlock Chain Event Class
ReplyDeleteJoin Operations - LEFT JOIN, RIGHT JOIN
Ebook Download Centre
https://download.microsoft.com/download/f/f/6/ff62cae0-ce38-4228-9025-fbf729312698/
Index Rebuild & Update Statistics
LIKE function
String Functions
CONCAT
CONCAT_WS
DIFFERENCE
SUBSTRING
TRANSLATE
STRING_SPLIT
Perform volume maintenance tasks- Windows Security
https://learn.microsoft.com/en-us/windows/security/threat-protection/security-policy-settings/perform-volume-maintenance-tasks
Common Language Runtime (CLR) Integration
https://learn.microsoft.com/en-us/sql/relational-databases/clr-integration/common-language-runtime-integration-overview?view=sql-server-ver16
सम्मान और नीयत की अच्छी छवि हमेशा धाक या कहें तो पहचान बनाती है और जीत दिलाती है!
ReplyDeleteAdditionally,
Roles, Administer Servers
CheckDB
REPAIR_ALLOW_DATA_LOSS | REPAIR_FAST | REPAIR_REBUILD
https://learn.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver16
जब मॉडल database में काम के Object भरवा कर नए डेटाबेस को create किया जाता है तो same database ही तैयार होता, चाहे बाद में इसको तूल ना दिया जाए फिर भी ये हमेशा अपने जैसा ही DB create करता रहेगा!
इसके अतिरिक्त
किसी के हस्तक्षेप का कोई चित्र तो नहीं पर Error लॉग में entry जरूर हो जाती है!
लॉग का जड्ढा service restart के बाद अपने आप cycle हो जाता है!
सुविचार थोड़ा नया.
नि शब्द, अमित वेद की नमस्ते.
Imp. Waittypes
ReplyDeleteAUDIT_GROUPCACHE_LOCK
AUDIT_LOGINCACHE_LOCK
GHOSTCLEANUPSYNCMGR
Internal Use only
https://techcommunity.microsoft.com/t5/sql-server-support-blog/unable-to-execute-a-remote-stored-procedure-over-a-linked-server/ba-p/316040
ReplyDeleteEXTENDED_LOGICAL_CHECKS
ReplyDeleteIf the compatibility level is 100, introduced in SQL Server 2008 (10.0.x), this option performs logical consistency checks on an indexed view, XML indexes, and spatial indexes, where present.
How DBCC CHECKDB creates an internal snapshot database beginning with SQL Server 2014
ReplyDeleteMAXDOP
ReplyDeleteApplies to: SQL Server 2014 (12.x) Service Pack 2 and later versions
Overrides the max degree of parallelism configuration option of sp_configure for the statement. The MAXDOP can exceed the value configured with sp_configure. If MAXDOP exceeds the value configured with Resource Governor, the SQL Server Database Engine uses the Resource Governor MAXDOP value, described in ALTER WORKLOAD GROUP.
TABLOCK
ReplyDeleteCauses DBCC CHECKDB to obtain locks instead of using an internal database snapshot. This includes a short-term exclusive (X) lock on the database. TABLOCK will cause DBCC CHECKDB to run faster on a database under heavy load, but will decrease the concurrency available on the database while DBCC CHECKDB is running.