• About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Disclaimer and copyright
Sql server Blog Forum

Helping SQL server DBAs and Developers

  • About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Disclaimer and copyright
  • About Me
  • #SQLHelp
  • SQLTools
  • AutoMon
  • jDBA
  • Tuning
  • Training
  • Oracle
  • Forum
  • Disclaimer and copyright
  • DBA,  Performance

    Performance Tuning Steps Query by looking an execution plan and effectiveness of the index Part 2

    August 25, 2019

    How to read execution plan to improve poorly performing queries Execution plan is optimizer’s calculation of how the query will be executed by creating the best low-cost query plan (if it is already in the cache, it will reuse).  SQL server is cost based optimizer.  Meaning, the optimizer decides based on CPU, I/O and statistics etc and creates a plan and returns the results. Up to date statistics is very important one to create a more accurate plan. We can view this in GUI and text both will be helpful, when the scenario come in.   Types:  Estimated and Actual execution plan – both will be helpful. Estimated plan: It…

    Read More
    Muthukkumaran Kaliyamoorthy No Comments
  • DBA,  Performance

    Performance Tuning Steps a Query by looking an execution plan and effectiveness of the index creation Part-1

    July 3, 2019

    The index is very important and powerful object in the database. It is an optional and secondary object for the table. It will speed up the data return time by navigating the B-tree structure, like a book’s index. In General, index tuning is important one, putting a right index will speed up the code.  Please read this post for finding symptoms, where you have issue at server or database or query level.  Most of the time, the query will be the issue. Once, you have long running query start tuning it. In this post, I am going to share the usage and effectiveness of index from low level to high…

    Read More
    Muthukkumaran Kaliyamoorthy 2 Comments

Search box

Categories

  • AlwaysON
  • AutoMon
  • Azure
  • Backup/Restore
  • Basics for freshers
  • DBA
  • Docker
  • DR/HA
  • Indexes
  • Internals
  • Junior DBA
  • Microsoft
  • Oracle
  • Performance
  • PowerShell
  • Questions
  • Scripts
  • SQL party
  • T-SQL
  • VLDB

Archives

Top SQL server blogs

  • Adam Machanic
  • Amit Banerjee
  • Brent Ozar
  • Gail Shaw
  • Grant Fritchey
  • Paul White
  • Pinal Dave
  • SimpleTalk
  • Sqlblog
  • SQLskills

Top Posts & Pages

  • Login failed for [SQLSTATE 28000] (Error 18456) the step failed
    Login failed for [SQLSTATE 28000] (Error 18456) the step failed
  • The Cluster service failed to bring clustered service or application completely online or offline. One or more resources may be in a failed state.
    The Cluster service failed to bring clustered service or application completely online or offline. One or more resources may be in a failed state.
  • Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
    Test connection failed because of an error in initializing provider. Oracle client and networking components were not found
  • AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
    AlwaysON database NOT SYNCHRONIZED and RECOVERY PENDING
  • TempDB database is Full and Optimization
    TempDB database is Full and Optimization
  • Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool 'internal' to run this query.
    Error: 17300, Severity: 16, State: 1. (Params:). The error is printed in terse mode because there was error during formatting. Tracing, ETW, notifications etc are skipped. There is insufficient system memory in resource pool 'internal' to run this query.
  • Microsoft SQL Server Migration plan and steps
    Microsoft SQL Server Migration plan and steps
  • Patch Update apply and automate SQL server patch for multiple servers patching compliance by DBATools Powershell
    Patch Update apply and automate SQL server patch for multiple servers patching compliance by DBATools Powershell
  • AlwaysON database not synchronizing suspect mode
    AlwaysON database not synchronizing suspect mode
  • SQL server failed to start the system cannot find the path specified
    SQL server failed to start the system cannot find the path specified
Savona Theme by Optima Themes