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.
| Author |
Topic |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-04 : 12:39:13
|
| 1. where do we see the buffer cache hit ratio. can we set the buffer catche hit ratio manually.2.In query execution plan we execute the query for performance issue.which parameters we check to take an action? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-04 : 12:41:31
|
| 1) In Performance Monitor- Memory2)check CPU I/O cost, Percentage,and which indexes are used and not used. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-05 : 23:08:52
|
| Look at execution plan, check all table scan and clustered index scan events. |
|
|
|
pootle_flump
1064 Posts |
Posted - 2008-04-07 : 05:06:28
|
quote:
Originally posted by rmiao
Look at execution plan, check all table scan and clustered index scan events.
Depends on the query. SELECT * FROM table is going to scan whatever! We have genuinely had someone asking us on dbforums how to optimise a query like that using indexes.Having said that, hash joins are often fertile ground for optimisation too. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-07 : 23:36:30
|
| Hope OP doesn't have that kind of query. |
|
|
|
|
|
|
performance