Pages

▼

Friday, May 19, 2023

MS-SQL Server - अनदेखा

अनदेखा


रोज अगर अपनी 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.

at

12 comments:

  1. AnonymousMay 20, 2023 at 7:26 PM

    🍁🌹SQL Server has power to bring Happiness because of Rollback🙏

    ReplyDelete
  2. AnonymousMay 22, 2023 at 10:37 AM

    बड़ी environment में, दो ही दिनों में Maintenance की लगाई हुई scripts का प्रभाव पता लग जाता है, अगर in between कोई issue आए तो THEY (I mean DBA) can check और बिना रोके और उसे नोन इश्यू समझ कर लिख भी सकते हैं, ये काम थोड़ा हट कर बिना services बंद किए, किया जा सकता है, कुछ options deprecated हो गए हैं, जो अब पुराने editions पर ही चलते हैं! अर्थात maintenance जरूरी है!

    ReplyDelete
  3. AnonymousMay 24, 2023 at 5:42 PM

    इसके अतिरिक्त,

    जब कोई आवाज दे तो हम तुरंत respond करते हैं, यद्यपि SQL Server में ऐसा सिर्फ Database mail और Alert Notification के साथ संभव हो सकता हैं critical alert आते ही जब आप सर्वर दिखायेंगे तो ज्यादातर DBA एक ही दिन में RCA Provide कर देते हैं, अलर्ट और response आता जाता रहता है, और इसे बिना रोके एक नोन इश्यू हट जाता है या रिजॉल्व कर देते है

    ReplyDelete
  4. AnonymousMay 28, 2023 at 3:03 PM

    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

    ReplyDelete
  5. AnonymousMay 28, 2023 at 3:55 PM

    Ent.Edt. Features
    - Log Shipping
    - Intelligent Database: Degree of Parallelism feedback
    - Intelligent Database: memory grant feedback persistence and percentile
    - Encrypted backup

    ReplyDelete
  6. AnonymousMay 29, 2023 at 6:34 PM

    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

    ReplyDelete
  7. AnonymousMay 31, 2023 at 6:11 PM

    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

    ReplyDelete
  8. AnonymousJune 2, 2023 at 5:54 PM

    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

    ReplyDelete
  9. AnonymousJune 9, 2023 at 1:48 PM

    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

    ReplyDelete
  10. AnonymousJune 10, 2023 at 11:12 AM

    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

    ReplyDelete
  11. AnonymousJune 13, 2023 at 6:48 PM

    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

    ReplyDelete
  12. AnonymousJune 29, 2023 at 11:47 AM

    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

    ReplyDelete