I have a report with a table, and with a big query who contains 4 parameters.
If users choose some parameters the query is fast but sometime it s very slow...
In the SQL Server Profiler , I can see that is really the query who's very long .
With the ApllicationName ".Net SqlCLient Data Provider" the query during 5mn30
if i execute the same query with replaced parameters in SQL Sever Management , it s ok .
(with SQL Profiler : ApplicationName "Microsoft SQL Server Management" during time = 2s )
Someone can help me ? Is there anything to increment memory cache or something like that ? ...Let's take a look at your query.
No comments:
Post a Comment