Performance - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Performance

Author

Topic

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2010-06-04 : 14:56:19

Hi ,

Appreciate help for the following question on sql 2005:

1) How do I ensure all my indexes are optimize?
2) How do I determine which are my the tables/indexes that causing phycical i/o?
3) How do i ensure my query is not causing a physical i/o read?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-04 : 15:14:11

1. Check fragmentation and ensure statistics are updated on a regular basis.
2. Check reads/writes in Profiler, but you'll be looking at the query level.
3. Check read/writes in Profiler

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

zaty2405
Yak Posting Veteran

58 Posts

Posted - 2010-06-09 : 00:26:54

thanks Tara..

I already run the profiler and found the stored procedure that having high reads.

Any recommendation on how to reduce the number of reads for this stored proc?

Thanks

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-06-09 : 11:28:15

Check for missing indexes. Look at the execution plan of the query.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-06-09 : 17:20:04

Interview? Homework?

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources