Sql server updating large databases Straight men chat room


SQL Server processor utilization tends to be high for short periods of time.

The current version of servers that are available with quad-core processors and significantly faster Serial Attached SCSI (SAS) drives capable of 3Gbps transfer rates represent a quantum leap in server performance.

With a proper clustered index, less reads are required to retrieve the records requested by a query or stored procedure.

Therefore, fewer disk I/O are preformed and the operation is completed faster.

Virtualization can take advantage of the processing power of this new generation of servers, providing significant leverage for your hardware dollar. Traditionally, SQL Servers run on dedicated hardware.

This gives the server full access to all the processing power on the server.

Related: Essential Tips for Virtualizing SQL Server Most SQL Server installations don’t use 100 percent of a server’s resources all the time.



Table 1 shows what can be tracked with the two features.SQL Server is one of the few Microsoft server applications that has the potential to place a significant load on the processor, especially if your application deals with large tables or high transaction volume.



Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>