Performance Tuning and Query Analysis in MS SQL Server 08

http://www.learningsqlserver2008.com/products.htm

Using SQL Server 2008, we kick off this performance tuning series. Will use SQL Profiler in MS SQL 08 and Query Execution Plan. We look at tips like limiting column in the result set, using primary keys and focusing on the WHERE clause in SQL Statement. Go over items like table scan, index scan, index seek, logical reads, CPU, query cost, SQL Server management studio, buffer cache, set statistics and query analysis.

Visit our other sites:

http://www.learningcomputer.com
http://www.learningsqlserver2008.com
http://www.sqlazuretutorials.com
http://sqlserver2008tutorial.com/sql-tutorials.html
http://compare-insurance-car.com/insurance_coverage.html
http://www.mycar-insurance.net
http://datatechnologyllc.com/search-engine-optimization/Dallas-SEO.html

Category:

Science & Technology

Tags:

• using SQL Server 2008
• performance tuning
• SQL Profiler
• MS SQL 08
• Query Execution Plan
• limiting columns
• result
• set
• primary keys
• WHERE clause
• SQL Statement
• table scan
• index scan
• Index Seek
• logical reads
• CPU
• query cost
• SQL Server management studio
• buffer cache
• set statistics
• query analysis

[mrp2003]

We are using SQL Server 2005, We have a stock table that we insert and query data every minute, The database is about 35MB in size now The stock table in question has 6,490 records.so it's not considered BIG.Many users connects to Server to retrieve data. When I do any query on the PC most of the times calling out a stock records can take 25s. It normally should be instantaneously...Is it because Server has many requests at the same time or is it due to too many data store in the table ?

[baghul]

@mrp2003 I would need to more about the table, how many columns, also the SQL statement, any joins. Also I would suggest using keywords like "WITH NOLOCK" to avoid locking if there are many users. If the table is wide (many columns) try not using select * or create a view. Good Luck

[benjostoked]

Great Job.. I want to be an SQL Dba... and searching for videos like this.. thanks for creating a simple and informative video.

[baghul]

@benjostoked You are very welcome! We have more FREE videos on site.

[seandeyoung01]

Nice job! Simple, straight-forward, and informative. Thanks!

[baghul]

@seandeyoung01 Thx buddy!

[goingy]

I only have a Results and Message Tab, what do I need to do to add in the Execution Plan? Thanks

[baghul]

@Kehindek Thank you Sir!

[baghul]

@sawalpalekar Thank you Sir!

[Kehindek]

Good job!