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
 Transact-SQL (2005)
 How to find out???

Author  Topic 

shubhada
Posting Yak Master

117 Posts

Posted - 2007-02-27 : 03:23:13
Hi,
The database on which I am working, have 220 stored procedures.
I have to find out the procedures those have parameter sniffing problems. How I can find out???
Have any methode to find out this parameter snifffing problem.

mahesh_bote
Constraint Violating Yak Guru

298 Posts

Posted - 2007-02-27 : 03:53:02
can anybody tell us, what the parameter sniffing is?

thanks in advance,

Mahesh
Go to Top of Page

shubhada
Posting Yak Master

117 Posts

Posted - 2007-02-27 : 03:59:19
Ya I have gone through some of links avaliable on net related to parameter sniffing...

SQLTeam
Go to Top of Page

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2007-02-27 : 04:27:39
Why do you keep posting the same problem over and over again?
Please keep this threads alive until problem solved, or until it is obvious you want something else than you have written in the header.

You have got several response here!
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79648
http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=79651


Peter Larsson
Helsingborg, Sweden
Go to Top of Page
   

- Advertisement -