Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kpsreenath
Yak Posting Veteran
52 Posts |
 Posted - 2006-02-20 : 14:01:00
|
| HI AllRecently I was reading an article on SQL Server performance.This is one of the statements " If you have any experience with performance tuning SQL Server 6.5, you may have heard that is not a good idea to add a clustered index to a column that monotonically increases because it can cause a "hotspot" on the disk that can cause performance problems. "Whats a hotspot and how does it affect the performance of a databaseAny articles or links towards the same would be highly helpfulThanks in advanceSreenath |
|
|
under2811
Constraint Violating Yak Guru
366 Posts |
Posted - 2006-02-20 : 14:51:03
|
| hi..that cause page split....which is not good health.... |
 |
|
|
JoeNak
Constraint Violating Yak Guru
292 Posts |
Posted - 2006-02-20 : 16:17:53
|
| A hot spot is an area of a disk that is receiving a lot of activity (read and write) at the same time. With an increasing column like an identity, the hot spot is at the end. (Table is storing in the index order). SQL Server Performance is a good site. This link is a little dated (7.0), but take a look. http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql7/html/msdn_sql7perftune.asp |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2006-02-20 : 17:53:48
|
| a hotspot just refers to a particular disk that is "hot" because it is receiving a lot of disk i/o.if you continue reading the article you referred to at sql-server-performance.com (http://www.sql-server-performance.com/clustered_indexes.asp) the author goes on to correctly reccomend putting clustered indexes on columns that are contain constantly increasing values. read the article for the details. This issue was only and issue with SQL 6.5, not with SQL 7 and newer.-ec |
|
|
|
Kristen
Test
22859 Posts |
Posted - 2006-02-20 : 18:37:17
|
| I was getting worried there. Thanks ec!Kristen |
|
|
|
kpsreenath
Yak Posting Veteran
52 Posts |
Posted - 2006-02-20 : 20:29:04
|
| Thanks a lotSreenath |
|
|
|
|
|
|
Question on hotspots