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

🎨🛠️ 𝗩𝗮𝗻𝗶𝗹𝗹𝗮 𝗙𝗿𝗮𝗺𝗲𝘄𝗼𝗿𝗸 𝘁𝗼 𝗘𝗺𝗽𝗼𝘄𝗲𝗿 𝗗𝗲𝘃𝗲𝗹𝗼𝗽𝗲𝗿𝘀 🚀🌐

Nexverse Digital Solutions_SaaS

📉 Solana Price Continues Downward Slide — Is a Rebound Possible at $180? 🚀

what is Interpretor ?