Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Increase performance on write
Message
De
11/02/2016 17:52:23
 
 
À
10/02/2016 18:01:51
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows 2008 Server
Divers
Thread ID:
01631211
Message ID:
01631345
Vues:
50
>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.

The first point to investigate is the interweaving of the lock when writing ( SQL Profile is a basic start point ).
This depends on the database and application design, and the number of competing operations.

The time can be reduced by improving the hardware,
but the minimum value depends on the design.
One way to find the minimum is to use ( not in production ! ) a Cache RAM (PrimoCache) that hides the disk latency.
Then you can compare this benchmark with a RAID controller with DRAM cache and SSD storage.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform