Home Forums SQL Server 2008 SQL Server 2008 Performance Tuning Help diagnosing performance issue RE: Help diagnosing performance issue
Tom Goltl
SSCertifiable
Points: 5755
More actions
December 15, 2014 at 9:59 am
#1764760
You can try looking at the query plan to see if it doing tablescans during the procedure, and index appropriately. I would definitely read the link about parameter sniffing.
Tom