June 29, 2011 at 12:55 pm
Hello,
I have some users experiencing performance issues. The database is the backbone for an application. The users are performing a task that is taking up to 12 seconds. This task has simply been described to me as 'pulling a slip' (regardless of my attempts to get more information from anyone and everyone). So for all intents and purposes I would assume this is a stored proc that either performs a query or accepts parameters to create a custom packaging slip (like fedex)....
The business contact is claiming that the rest of the application is running fine, its just this one task.
Anyway, the vendor has worked with the business contact and has claimed to be able to perform this task on our app server in less than a second. Where as users performing this through the app on their desktop, it is taking them up to 12 seconds or so.
I've run a trace in coordination with perfmon (mostly disk IO counters), tracing stored procedures,tsql and locks. But how do I interpret this?
June 29, 2011 at 1:56 pm
thank you!
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply