Walter Meester
HoogkarspelPays-Bas
Information générale
Forum:
Microsoft SQL Server
Versions des environnements
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,
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement