please analyze the iostastistics

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

General SQL Server Forums

New to SQL Server Programming

please analyze the iostastistics

Author

Topic

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-17 : 08:24:52

dear all,
i've the following result with huge number of logical reads. please analyze the result and suggest me the best to tune the database

(5851027 row(s) affected)
Table 'MainInfo'. Scan count 1, logical reads 60489, physical reads 3, read-ahead reads 60485, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Arnav
Even you learn 1%, Learn it with 100% confidence.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-07-17 : 08:28:14

you'll have to show us your query.

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-07-17 : 08:29:08

just the select query
select * from MainInfo

Arnav
Even you learn 1%, Learn it with 100% confidence.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-07-17 : 08:34:42

add a clustered index on it. other than that for select without where you can't do much else...
if you have to select all i guess you can use this method to speed it up a bit:
http://weblogs.sqlteam.com/mladenp/archive/2006/04/04/9503.aspx

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.0 out!

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2008-07-17 : 14:28:31

You're asking for the entire table, all columns, all rows. There's no way to process that without reading the entire table.

--
Gail Shaw
SQL Server MVP

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2008-07-17 : 14:38:35

quote:
Originally posted by sunsanvin

dear all,
i've the following result with huge number of logical reads. please analyze the result and suggest me the best to tune the database

(5851027 row(s) affected)
Table 'MainInfo'. Scan count 1, logical reads 60489, physical reads 3, read-ahead reads 60485, lob logical reads 0, lob physical reads 0, lob read-ahead reads 0.

Arnav
Even you learn 1%, Learn it with 100% confidence.

What makes you think that logical reads are a problem? Do you know what they are?

CODO ERGO SUM

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources