Clients Statistics deletion problem

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)

Clients Statistics deletion problem

Author

Topic

chorofonfilo
Starting Member

40 Posts

Posted - 2012-09-07 : 16:48:23

Hi to everyone and thanks for your help in advance.

I am using client statistics for the first times, and every time I am using the reset button to clear them up, the oldest trials are still showing up.

How can I effectively delete the client statistics so all new trials start all over?.

Perseverance worths it...:)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-07 : 17:00:12

It doesn't seem that you have a SQL Server question. Could you explain in greater detail?

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

Subscribe to my blog

chorofonfilo
Starting Member

40 Posts

Posted - 2012-09-07 : 17:15:33

quote:
Originally posted by tkizer

It doesn't seem that you have a SQL Server question. Could you explain in greater detail?

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

Subscribe to my blog

Hi Tara

I'll try again. Basically I am using Sql Server 2005 Client Statistics option of the Management Studio to measure the performance of a query.
I am trying to delete the old information for each trial set by the statistics feature on my query using "Reset Client Statistics" button, but the deletion isn't performed and is still showing the data of the old trials eg:

Trial 2 Trial 1 Average

0 0 0.0000
1 1 0.0000
2 2 1.7000
0 0 0.0000

I wonder how can I do to delete the old info (Trial 2,Trial1) and start all over again.

Thank you

Perseverance worths it...:)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-07 : 17:16:58

I am not familiar with that option. I use SET STATISTICS TIME ON and SET STATISTICS IO ON when doing performance testing. I also examine the execution plans. Be sure to free the procedure cache and drop the clean buffers in between each test.

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

Subscribe to my blog

chorofonfilo
Starting Member

40 Posts

Posted - 2012-09-07 : 17:20:02

quote:
Originally posted by tkizer

I am not familiar with that option. I use SET STATISTICS TIME ON and SET STATISTICS IO ON when doing performance testing. I also examine the execution plans. Be sure to free the procedure cache and drop the clean buffers in between each test.

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

Subscribe to my blog

Sounds like the way to go. Could you please tell me how to free the procedure cache and clean the buffers?.

Thank you

Perseverance worths it...:)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-07 : 17:27:07

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

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

Subscribe to my blog

chorofonfilo
Starting Member

40 Posts

Posted - 2012-09-07 : 17:31:28

quote:
Originally posted by tkizer

DBCC FREEPROCCACHE
DBCC DROPCLEANBUFFERS

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

Subscribe to my blog

I tried using both commands but the old info is still showing even when I disconnect from the query analyzer and connect again.
Maybe that info can't be really cleared up and will always show?.

Perseverance worths it...:)

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-09-07 : 17:40:20

I wasn't suggesting that it would clear your issue. What I'm suggesting is that you change your method of performance testing.

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

Subscribe to my blog

chorofonfilo
Starting Member

40 Posts

Posted - 2012-09-07 : 18:02:29

quote:
Originally posted by tkizer

I wasn't suggesting that it would clear your issue. What I'm suggesting is that you change your method of performance testing.

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

Subscribe to my blog

Thanks, your option is very interesting and straightforward. I've found a basic overview to use it here:
http://vadivel.blogspot.com/2012/03/query-tuning-using-set-statistics-io.html

I've restarted the management studio and the old stat info is not there anymore, but I think there should be a way to do so without closing anything so any extra help would be also appreciated.

Perseverance worths it...:)

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources