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 |
|
kid_on_the_block
Posting Yak Master
172 Posts |
 Posted - 2006-02-19 : 22:36:13
|
| How does one figure out, I mean compare the results after some changes have been done to the SQL Server, I mean the method in which the comparision is done, lets say I have a query I ran it it gave me the results in 40 seconds , I ran it again this time it took 30 seconds, then I again ran it it took 35 seconds, I then created an index , this time the query ran in 30 seconds ... how does one compare such things , I mean i need to give stats as too what kind of performace has takern place ... please helpo , I need to knw as a DBa how would you convince your maanger that becasue of some changes the performance has improved, cause when you ask the users they say its ok , we dont see the differnece & stuff , please help. |
|
|
mary_itohan
Posting Yak Master
191 Posts |
Posted - 2006-02-20 : 05:29:50
|
| >> I mean I mean, whats your point ?Yes O ! |
 |
|
|
Norwich
Posting Yak Master
158 Posts |
Posted - 2006-02-20 : 06:43:25
|
Perfomance Monitor?- Memory usage
- CPU processor
- Disk I/O performance
- User connections
NThe revolution won't be televised! |
|
|
|
kid_on_the_block
Posting Yak Master
172 Posts |
Posted - 2006-02-21 : 00:34:07
|
| ok when i am checking the counters, do we add only the memory object first ,or should I add all of them together. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-21 : 00:39:20
|
| good question. I often have to give numbers to people so they can see what the improvement is. Here is what I do.In query analyzer, do the following:1. SET STATISTICS IO ON2. SET STATISTICS TIME ON3. turn on the execution plan4. run your query5. make your indexing change6. run the steps 1-4 in a new session of Query analyzerThis way you have the output showing the STATISTICS IO and TIME for both the before and after change. This is very helpful in seeing how many logical and physical IOs take place, how many milliseconds a query takes, etc. You can then also see the execution plan to see how the plan has changed.This information, along with the execution plan output should be enough to show management that a query is now executing more efficiently. -ec |
|
|
|
|
|
|
|
|
A Challenging Question