sql server responding slow

Analyze the 48 causes of slow SQL query. There are many reasons for slow query speed. The following are common causes: 1. No index or no index is used (this is the most common problem of slow queryProgramDesign defects) 2. Low I/O throughput, resulting in a bottleneck effect. 3. the query is not optimized beca

split the table to reduce the table size (sp_spaceuse)3. upgrade hardware4. Create an index based on the query conditions, optimize the index, optimize the access mode, and limit the data volume of the result set. Note that the fill factor should be appropriate (preferably the default value 0 ). The index should be as small as possible. Use a column with a small number of bytes to create an index (refer to the index creation). Do not create a single index for fields with a limited number of val

Slow SQL query speedThere are many reasons for slow query speed in SQL Server databases. The following are common causes: 1. No index or no index is used (this is the most common problem of slow query and is a defect in programmin

silent unlocked unlocked unlocked not locked NOLOCK unlocked unlocked unlocked HOLDLOCK shared share share update UPDLOCK error update update TABLOCKX error Unlocked not Lock update other unlocked unlocked Unlocked update * Specifies that the NOLOCK hint will make the table specified with this hint read-only in cursor. 16. Use Profiler to track the query, get the time required to query, find out the problem of SQL; Optimize index 17 with the index Op

is much more efficient.Set global general_log = off; alter table general_log engine = MyISAM; # the innodb format set global general_log = on cannot be used; # By default, general_log is in csv format. modifying it to MyISAM is much more efficient.Set global slow_query_log = off; equal to 0. alter table slow_log engine = MyISAM; # set global slow_query_log = on in innodb format; equal to 1 3. Because mysql Log tables general_log and slow_query_log cannot be modified, you need to create a new ta

. This is a powerful tool when DBA finds the cause.5. When using mysqlbinlog for analysis, you can get a clear period of time when the database status is abnormal.Some people will make mysql Configuration File Settings. Some other parameters are found when tmp_table_size is adjusted.Qcache_queries_in_cache number of queries registered in the cacheQcache_inserts number of queries added to the cacheQcache_hits cache sample countQcache_lowmem_prunes number of queries deleted from the cache due to l

the table vertically and horizontally to reduce the table size (sp_spaceuse) 3) upgrade hardware 4) Create an index based on the query conditions, optimize the index, optimize the access mode, and limit the data volume of the result set. Note that the fill factor should be appropriate (preferably the default value 0 ). The index should be as small as possible. Use a column with a small number of bytes to create an index (refer to the index creation). Do not create a single index for fields

Analysis and solution to slow mysql server query Some developers, especially those who have contact with mysql, may encounter slow mysql queries. of course, I am referring to a large data volume of millions or tens of millions, not dozens of times, next we will look at the solution to slow query. Developers often find

horizontally split the table to reduce the table size (sp_spaceuse) 3. upgrade hardware 4. Create an index based on the query conditions, optimize the index, optimize the access mode, and limit the data volume of the result set. Note that the fill factor should be appropriate (preferably the default value 0 ). The index should be as small as possible. Use a column with a small number of bytes to create an index (refer to the index creation). Do not create a single index for fields with a limite