Can someone provide answers for my questions below?

I am a newbie to MS SQL. We are using MS SQL 2008 R2 in Windows 2008 server.

1). I  want to tune a developer's queries, views and stored procedure. How can I open up the explain plan from Management Studio?

2). Can you list most common MS SQL server administration commands for DB admin to manage the server?

3). If complained the query running very slow or the report running slow, what steps should I take to troubleshoot this issue?
wasabi3689Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TempDBACommented:
1. There are two kind of execution plans.

Shortcut for Display Estimated Execution Plan : CTRL + L
Shortcut for Include Actual Execution Plan : CTRL + M

2. Commands are based on what operation you are performing.. Following link should help you and then you can google anytime to check what are those commands:-
http://www.mssqltips.com/sqlservertip/1240/sql-server-dba-checklist/

3. Check the execution plan of the query, the blocking stats, try using profiler to find out what is the real statement taking time. Then check the indexes on the table, the type of join being used, etc.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Scott PletcherSenior DBACommented:
Those are all very heavy topics.  Whole books have been written about each one individually.

I suggesting buying some of those books.  You can rely on anything by Kalen Delaney or Itzik Ben-Gan.  Otherwise check book reviews and research the authors to determine how good the books are.
0
wasabi3689Author Commented:
I want a big topic but with simple answer here.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.