question

SQLserverlover avatar image
SQLserverlover asked

Need help with SP

Please help with my SQL query I have a stored procedure in my production environment. When a single user calls that SP through application it takes 4 seconds to execute and respond, but when it comes to concurrent users say 50 it then start taking more than 60 seconds. I have configured 4 tempdb files as Machine has 4 logical processors.
sql-server-2012stored-proceduresperformance-tuningsql-server-2014
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
Which version? you tagged 2012 & 2014... Not that that's likely to be an issue... What is, though, is that you give us very little to go on. What's the procedure actually doing/ How much data is being moved? What's the query plan? What are the indexes? What's the server configuration? And the storage? Those would be useful to know...
1 Like 1 ·

1 Answer

·
SQLserverlover avatar image
SQLserverlover answered
Hi ThomusRushton, Please give me some more time. I will respond you back in few hours Thanks for your help
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.