Performance issu
Hello while developing a report , i first worte a stored procedure witch gets few parameters. while executing the stored procedure in Managment studio the procedure ran for about 2 Sec. Now , I have a new report with new Shared DataSource and with one RDL. I have created a new dataset witch called the stored procedure i have written. the problem is that the time it takes the dataset to bring back the result from the procedure itws like forever (a lot of minute). does any body know the reason to the gap between running SP in Managment Studio and running it in VB Project. thsnks,
December 15th, 2010 4:01am

It is possible because of parameter sniffing http://pratchev.blogspot.com/2007/08/parameter-sniffing.htmlBest Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2010 4:09am

I undetstand what is parameter sniffing but I run the procedure with the same parameters in both ways, also in the managment studio and in the VBS so in both cases the same query plan sholud be taken but the time it tooks the query to execute is by far not the same. I undetstand what is parameter sniffing but I run the procedure with the same parameters in both ways, also in the managment studio and in the VBS so in both cases the same query plan sholud be taken but the time it tooks the query to execute is by far not the same.
December 15th, 2010 4:30am

oOk, can you compare an execution planS of that query riunning from (SSMS) and SSRS????Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
Free Windows Admin Tool Kit Click here and download it now
December 15th, 2010 4:43am

How many values or rows the SP returns? Also it may be due to bandwidth issues between the server you are trying to view the report and SQL Server. For good analysis open the SQL Server profilier and check the SP execution times in both cases it would give you a better insight.
December 15th, 2010 5:03am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics