Walter Meester
HoogkarspelNetherlands
General information
Forum:
Microsoft SQL Server
Environment versions
SQL Server:
SQL Server 2014
Network:
Windows 2008 Server
>Is there any possibility of doing actions that will improve the performance on writes? I understand the writing procedure from SQL Server would take more time than regular SQL select and that indexes are a factor, but if there is something I am missing, I would like to know about it.
Michel,
The first most opvious one is to use a fast disk system (e.g. a fast SDD) to speed up writes.
Second, check the clustered index. For best performance an 4byte autoincremental integer key is best. Since indexes will have a pointer to the clustered key it will keep the indexes as small as possible. The autoincrement will also prevent rows being moved from one page to another when the indexvalue of the clustered index changes.
Also look at whether you really need all indexes, esspecially the compound ones. If an index is not used, it is only taking up space and hurting performance in inserts and updates. Consider removing Indexes on low selective columns (typically boolean columns) as they general do no speed up queries much, but only cost diskspace and performance on inserts and updates
Walter,
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only