अनदेखा
रोज अगर अपनी Configuration को High या Low करेंगे तो SQL Server अचानक Fatal Error दे सकता है, जो हम अनदेखा कर देते हैं, एक अच्छे गुणी DBA की यही पहचान होती है की वे एक SOP बना कर environment को manage करते रहे! भले ही थोड़ी देर लगती है, पर शुरुवात में कुछ mandatory चीज़ें apply करके हम इसे achieve कर सकते हैं.
These are....
Directory Standards
Standards for Backup and Maintenance
Memory Configuration
MaxDOP
Fillfactor
CPU Affinity Mask
Recovery Model
DB Growth Standard
Startup Account / Password Change Policy etc..
Additionally,
Please also read on below topics....
- Keys and Constraints
- High Availability
- Enterprise Edition
छांव पर भी पड़ती सूरज की धूप!
Best Regards
T. Amit Vaid S.
12 comments:
🍁🌹SQL Server has power to bring Happiness because of Rollback🙏
बड़ी environment में, दो ही दिनों में Maintenance की लगाई हुई scripts का प्रभाव पता लग जाता है, अगर in between कोई issue आए तो THEY (I mean DBA) can check और बिना रोके और उसे नोन इश्यू समझ कर लिख भी सकते हैं, ये काम थोड़ा हट कर बिना services बंद किए, किया जा सकता है, कुछ options deprecated हो गए हैं, जो अब पुराने editions पर ही चलते हैं! अर्थात maintenance जरूरी है!
इसके अतिरिक्त,
जब कोई आवाज दे तो हम तुरंत respond करते हैं, यद्यपि SQL Server में ऐसा सिर्फ Database mail और Alert Notification के साथ संभव हो सकता हैं critical alert आते ही जब आप सर्वर दिखायेंगे तो ज्यादातर DBA एक ही दिन में RCA Provide कर देते हैं, अलर्ट और response आता जाता रहता है, और इसे बिना रोके एक नोन इश्यू हट जाता है या रिजॉल्व कर देते है
SUM
https://learn.microsoft.com/en-us/sql/t-sql/functions/sum-transact-sql?view=sql-server-ver16
Avg Function
https://learn.microsoft.com/en-us/sql/t-sql/functions/avg-transact-sql?view=sql-server-ver16
Additionally,
Hierarchical Data
The built-in hierarchyid data type makes it easier to store and query hierarchical data.
https://learn.microsoft.com/en-us/sql/relational-databases/hierarchical-data-sql-server?view=sql-server-ver16
Ent.Edt. Features
- Log Shipping
- Intelligent Database: Degree of Parallelism feedback
- Intelligent Database: memory grant feedback persistence and percentile
- Encrypted backup
Waittypes
PREEMPTIVE_COM_STRMSEEKANDWRITE
(Internal Use)
Standard Edt. Features
- Bulk insert improvements
- Standard performance reports
- Encrypted backup
- Log Shipping
Static SQL
https://learn.microsoft.com/en-us/sql/odbc/reference/static-sql?view=sql-server-ver16
UserName Password and Create a Login
https://learn.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-ver16
Visualisation Database Tools
https://learn.microsoft.com/en-us/sql/ssms/visual-db-tools/visual-database-tools?view=sql-server-ver16
Memory Grant Pending
https://techcommunity.microsoft.com/t5/sql-server-support-blog/memory-grants-the-mysterious-sql-server-memory-consumer-with/ba-p/333994
DAC
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/diagnostic-connection-for-database-administrators?view=sql-server-ver16
Shrink Data File
https://learn.microsoft.com/en-us/sql/relational-databases/databases/shrink-a-file?view=sql-server-ver16
Backup Verifyonly
Keys & constraints
Deep Analysis of Waittypes & Native Tools
Merge Function and Types of Joins
Performance Monitor & Char & varchar Datatypes
Waittypes
BACKUP
BACKUP_OPERATOR
BACKUPBUFFER
BACKUPIO
BACKUPTHREAD
Internal Use only
QDS_ASYNC_PERSIST_TASK_START
QDS_CLEANUP_STALE_QUERIES_TASK_MAIN_LOOP_SLEEP
App connection string
+ (String Concatenation) https://learn.microsoft.com/en-us/sql/t-sql/language-elements/string-concatenation-transact-sql?view=sql-server-ver16
Backup Database
Full, Differential T-Log
Apply a hotfix for SQL Server in a transactional replication and database mirroring topology
Imp. Waittype
HADR_DB_OP_START_SYNC
QUERY_EXECUTION_INDEX_SORT_EVENT_OPEN
Internal use
REMOTE_DATA_ARCHIVE_MIGRATION_DMV
Breaking changes in SQL Server 2016
Under database compatibility level 130, implicit conversions from datetime to datetime2 data types show improved accuracy by accounting for the fractional milliseconds, resulting in different converted values.
https://learn.microsoft.com/en-us/sql/database-engine/breaking-changes-to-database-engine-features-in-sql-server-2016?view=sql-server-ver16
KB5024396 - Cumulative Update 3 for SQL Server 2022
https://learn.microsoft.com/en-us/troubleshoot/sql/releases/sqlserver-2022/cumulativeupdate3
Domain Account
https://learn.microsoft.com/en-us/sql/database-engine/configure-windows/configure-windows-service-accounts-and-permissions?view=sql-server-ver16
Profiler
https://learn.microsoft.com/en-us/sql/tools/sql-server-profiler/sql-server-profiler?view=sql-server-ver16
Average of a count
https://learn.microsoft.com/en-us/answers/questions/435314/trying-to-get-the-average-of-a-count-resultset-usi
Begin Try Catch
https://learn.microsoft.com/en-us/sql/t-sql/language-elements/try-catch-transact-sql?view=sql-server-ver16
Post a Comment