i doing SQL tuning in Company databases but i don't know where to start

#sql

i am doing SQL tuning in Company databases but i dont know where to start as i am new in DBA i joined new company where they have lots of databases, and it issue with databases, can anyone help me where to i start what should be step

Top comments (3)

Helen Anderson • Jan 25 '20

Hi Biren

Looks like you're using Execution Plans for your tuning, is there anything specific you're struggling with?

What is an execution plan?

Biren ・ Jan 15 ・ 1 min read

#sql #azure #devops

Biren • Jan 25 '20 • Edited

Hi Helen,

please check below my Quote and write ahead what i can do as i am Nob DAB

first o go with indexing, i used sql profiler for trace query then i use SQL query adviser.... ? can i appliyed given recommendation or need to explore first

Helen Anderson • Jan 26 '20

Hi Biren,

Are you having trouble with SQL Profiler?

Check out these links to get started and for best practice:

Some comments may only be visible to logged-in visitors. Sign in to view all comments.

DEV Community

i doing SQL tuning in Company databases but i don't know where to start

Top comments (3)

What is an execution plan?

Biren ・ Jan 15 ・ 1 min read

Read next

Preventing SQL Injection (SQLi) in React.js Apps

On-Demand Refresh | Materialized Views (Mviews) in ORACLE SQL

5 Essential SQL Skills Learned from a Decade of Experience

How Pipe Syntax Fix SQL Design Problems