In our enviroment Sqll server running Slow & Also query running slow

Category: sql server multiservermgmt

Question

ajit kumar1991 on Wed, 08 Jan 2020 05:20:12


hi,

In our environment Sql server running Slow & Also query running slow.IT is performance issues., How to handle these think .


ajitkumar

Replies

Olaf Helper on Wed, 08 Jan 2020 06:27:19


By Investigating the cause, of course.

https://www.mssqltips.com/sqlservertip/4111/first-steps-for-sql-server-performance-troubleshooting/


Olaf Helper

[ Blog] [ Xing] [ MVP]


Dawn Young on Thu, 09 Jan 2020 01:51:05


Hello,

There are number of reasons why SQL Server running slow. Finding the cause of the performance bottleneck is vital.

Some of the biggest performance bottlenecks usually boil down to server causes:

  1. Missing indexes
  2. Poor index design
  3. Poorly designed database schema
  4. Inadequate storage I/O subsystem
  5. Buffer pool too small
  6. Slow network
  7. Wrong technology used

You can follow this article which tell the detail troubleshooting for SQL Server slow: https://www.itprotoday.com/sql-server/troubleshooting-slow-servers

 

Hope it will help.

Dawn Young on Fri, 10 Jan 2020 06:58:00


Hello,
Have you solved the question?
If you have resolved your issue, please mark the useful reply as answer. This can be beneficial to other community members reading the thread.
In addition, if you have another questions, please feel free to ask.
Thanks for your contribution.