Visiting Error Logs
Link....
View the SQL Server error log (SSMS) - SQL Server | Microsoft Learn
Additionally,
Facing performance issues, Keys/Keys and Constraints, High Availability, Bad Execution Plan, Maintenance Plan.
Named instance keys linked server
Non Clustered Index
Char Varchar datatypes, Plan Handle, Waittypes, Last Restore Time.
sys.dm_exec_query_plan (Transact-SQL) - SQL Server | Microsoft Learn
Imp. Waittypes
CXPACKET, NET_WAITFOR_PACKET,DEADLOCK_ENUM_MUTEX,DEADLOCK_TASK_SEARCH, FS_GARBAGE_COLLECTOR_SHUTDOWN,ASYNC_IO_COMPLETION
Other Topics
Multiple Join Examples, Raid Configurations, Native Tools, GAM, PFS, Related Corruptions.
Read-only DB, Tail log Backup Endpoints.
Remove Square Brackets from JSON - WITHOUT_ARRAY_WRAPPER Option - SQL Server | Microsoft Learn.
Any query will be considered.
Imp. Errors
T. Amit Vaid S.
Master DB, ACID, Keys, Scheduled Jobs, Architecture Diagram, SQL Agent
ReplyDeleteSox compliance, Shrink Log file, RESOURCE_GOVERNOR_IDLE, COLUMNSTORE_COLUMNDATASET_SESSION_LIST
Addressing Space issue by sp_spaceused and xp_fixeddrives, float and real (Transact-SQL), BROKER_TASK_SHUTDOWN,XE_PACKAGE_LOCK_BACKOFF, BROKER_EVENTHANDLER, Log Shipping,SQLTRACE_BUFFER_FLUSH,FT_IFTS_CHUNK_BUFFER_CLIENT_MANAGER,WINDOW_AGGREGATES_MULTIPASS, SQLCLR_QUANTUM_PUNISHMENT,
FS_GARBAGE_COLLECTOR_SHUTDOWN,PREEMPTIVE_OS_AUTHZINITIALIZECONTEXTFROMSID,BACKUPTHREAD.
Dealing with TORN_PAGE_DETECTION
ReplyDeletehttps://learn.microsoft.com/en-us/sql/t-sql/statements/alter-database-transact-sql-set-options?view=sql-server-ver16
Imp. Waittype
FT_IFTS_SCHEDULER_IDLE_WAIT
Internal use
FEATURE_SWITCHES_UPDATE
FT_IFTS_ASYNC_WRITE_PIPE
हमारे विचार और विमर्श एक स्तम्भ भी बना सकते है, पहले समय पर जब विश्लेषण करना होता था, तो हम सिर्फ़ एक automated report ही भेज देते थे, जबकि ऑटोमेशन हमेशा further verification और analysis expect करता है!
ReplyDeleteWAIT_ON_SYNC_STATISTICS_REFRESH
PRU_ROLLBACK_DEFERRED
FILE_VALIDATION_THREADS
ReplyDeleteSQLCLR_QUANTUM_PUNISHMENT
SQLTRACE_WAIT_ENTRIES
REDO_THREAD_PENDING_WORK
THREADPOOL
JDBC Driver, Java Connection URL
https://learn.microsoft.com/en-us/sql/connect/jdbc/building-the-connection-url?view=sql-server-ver16
ASYNC_DISKPOOL_LOCK
Native Client
https://learn.microsoft.com/en-us/sql/relational-databases/native-client/applications/installing-sql-server-native-client?view=sql-server-ver16
Email SPROC
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-send-dbmail-transact-sql?view=sql-server-ver16
Backup Device
ReplyDeletehttps://learn.microsoft.com/en-us/sql/relational-databases/backup-restore/backup-devices-sql-server?view=sql-server-ver16
Management Data Warehouse
https://learn.microsoft.com/en-us/sql/relational-databases/data-collection/management-data-warehouse?view=sql-server-ver16
Is_Snapshpt
https://learn.microsoft.com/en-us/sql/relational-databases/system-tables/backupset-transact-sql?view=sql-server-ver16
Backup Master Key
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/back-up-a-database-master-key?view=sql-server-ver16
Weighted Average
https://learn.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql?view=sql-server-ver16
HADR_DBR_SUBSCRIBER_FILTER_LIST
Case when, Monitor Memory Usage
ReplyDeletehttps://learn.microsoft.com/en-us/sql/t-sql/language-elements/case-transact-sql?view=sql-server-ver16
Erase Error Log
https://learn.microsoft.com/en-us/host-integration-server/core/how-to-clear-event-logs1
Another Imp. thing to add...
1. What are the advantages always square brackets sql server objects inside procedure.
https://learn.microsoft.com/en-us/answers/questions/414636/what-are-the-advantages-always-square-brackets-sql
2. AME - Again AME in regards to SQL Server is nothing but Analysing Major Errors, which we can filter out in our scripts.
Any query will be considered.
T. Amit Vaid S.
There are 15 aggregate Functions to discuss today...
ReplyDeleteAggreegate functions
https://learn.microsoft.com/en-us/sql/t-sql/functions/aggregate-functions-transact-sql?view=sql-server-ver16
Plus 3 G r a p h functions to learn
EDGE_ID_FROM_PARTS
GRAPH_ID_FROM_EDGE_ID
GRAPH_ID_FROM_NODE_ID
विचार की सदा हो जय, ये मन से लिखा करता हूं,
सबको खुश कर पाऊं, ये भी उम्मीद करता हूं!
Any query will be considered.
T. Amit Vaid S.
Waittypes
ReplyDeleteFT_IFTS_STOPLIST_CACHE_MANAGER
DLL_LOADING_MUTEX
PREEMPTIVE_CLOSEBACKUPMEDIA
SOS_MEMORY_USAGE_ADJUSTMENT
XE_DISPATCHER_CONFIG_SESSION_LIST
GLOBAL_TRAN_CREATE
PWAIT_MD_LOGIN_STATS
All Index Rebuild at once followed by Update Statistics
ReplyDeleteIf you require any help in terms of its script, please send mail to amitvaid81@gmail.com
जिस प्रकार एक अच्छी परफॉर्मेंस, स्वयं DBA का वर्णन देती है, उसी प्रकार सकारात्मक सोच हमारे अध्ययन का परिचय देती है!
पहला अक्षर SQL और Azure का, जिसमें 'SA' login का ज्यादा महत्व होता है!
और त्रिगर का उपयोग सालों की मेहनत ने बनाया था!
https://learn.microsoft.com/en-us/sql/t-sql/statements/create-trigger-transact-sql?view=sql-server-ver16
Any query will be considered.
T. Amit Vaid S.
काफी लोगों का र्रुख आप जब SQL Server की तरफ देखते और बताते हैं तो पिछले फीचर्स याद रहते हैं और नए फीचर्स की हमें भनक मिली तो मानो करियर का एक और टर्न मिला!
ReplyDeleteहम चमक लाने के लिए वार्निंग्स को एक लेवल पर रिजॉल्व करते हैं!
अब पहले से कहीं बड़े फीचर्स आ गए हैं!