Home » Topic » Slow SQL Performance on The Server

Slow SQL Performance on The Server

Stephen West ~ Modified: June 3rd, 2016 ~ ~ 1 Minute Reading

Home › Forums › Slow SQL Performance on The Server

Viewing 10 posts - 1 through 10 (of 10 total)
  • Author
    Posts
  • June 3, 2016 at 12:14 pm #2161 Score: 0
    Stephen West
    Moderator
    4 pts

    SQL performance seems particularly slow on the server – 20 seconds when compared to running the same query on our DEV servers against very similar data – 1 second (a recent copy)
    Could you please suggest me an approach to troubleshoot?

    June 6, 2016 at 11:24 am #2205 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    Have you compared the load factor, memory configuration between dev and prod environments?

    June 7, 2016 at 12:20 pm #2213 Score: 0
    Stephen West
    Moderator
    4 pts

    Average load factor is quite similar in either more or less 6.5

    June 9, 2016 at 11:54 am #2224 Score: 0
    Michael Scofield
    Moderator
    20 pts

    How did you estimate the load factor?

    June 13, 2016 at 12:01 pm #2240 Score: 0
    Stephen West
    Moderator
    4 pts

    SELECT AVG(load_factor*1.0) as avg_load_factor
    FROM sys.dm_os_schedulers
    WHERE scheduler_id < 255

    June 14, 2016 at 12:18 pm #2253 Score: 0
    Michael Scofield
    Moderator
    20 pts

    No the load factor I am talking about is the volume of data being processed in production and dev environment? It is possible that prod process more data with higher frequency compared to dev environment. This could cause difference in observed performance.

    June 15, 2016 at 12:31 pm #2266 Score: 0
    Stephen West
    Moderator
    4 pts

    No way because the prod database is backed up and restored quite often. Last restore is performed today
    So, the data should be same and the query is tested when no other transaction are there.

    June 16, 2016 at 12:53 pm #2268 Score: 0
    Kerry Morris
    Moderator
    34 pts

    Update statistics and optimize index.

    June 17, 2016 at 1:04 pm #2274 Score: 0
    Eddie Thwan
    Moderator
    44 pts

    Dev server is much users not connected but prod server n number of users are connected
    Update static and indexes, take recent backups, log backups and full backup as a possible and please check network speed. Heigh disk space also be more than database size

    July 22, 2016 at 11:24 am #2648 Score: 0
    Lincoln Burrows
    Moderator
    16 pts

    there could be several reasons behind of a SQL server database slow performance read here: http://www.sqlmvp.org/fixing-sql-server-database-performance-issues/

  • Author
    Posts
Viewing 10 posts - 1 through 10 (of 10 total)
  • You must be logged in to reply to this topic.