Slowness while executing SQL script from SharePoint to DB servers. RRS feed

  • Question

  • Developer team has written code on SharePoint 2007 to query with SQL DB but getting slowness (15-20 sec time to execute) while opening those pages having SQL related script.

    Same code running on QA and development farm but there is no slowness, code is executing within 3-4 sec only delay in Prod farm 15-20 sec.

    Is there any tool exist where we can know what causing delay on code level? CPU, memory and server performance are good for SharePoint and SQL servers.

    Friday, July 29, 2016 7:00 AM


  • It might the number of records or data size its handling on the production, normally on the dev and QA you won't have the data volume as compared to prod. Add some logging methods with time stamping in your custom code and identify the bottle neck. Try to do some caching also, it'll improve the performance.

    rjesh.com| @rjesh
    You don't need to buy me a beer, if helpful just smile, vote, and mark it as answer.

    • Marked as answer by Prakash KSingh Wednesday, October 26, 2016 11:26 AM
    Monday, August 1, 2016 3:02 PM