Browse by Tags

Address Windowing Extensions (AWE) requires the 'lock pages in memory' privilege which is not currently present in the access token of the process

Published 21 May 8 4:20 AM | SSQA.net

The main difference betwen 32 bit and 64 bit server is Memory, you may be aware about 'Lock Page in memory' privilege to be granted to the SQL Server service accout within 32 bit based servers. This is a operating system based privilege that is...

Filed under: sql server, best practices, 32 bit, 64 bit, configuration, service account, sp_configure, lock pages in memory

SQL Server configuration disk layout - best practices from field

Published 3 April 8 3:17 AM | SSQA.net

Configuration of server such as disk and memory is an important factor for SQL Server Performance, there is all about questions within newsgroups and forums that how do I setup the disk layout for a SQL Server database (say, 2005 version). Not only this...

Filed under: sql server, performance, data, log, disk, best practices, tempdb, monitoring, configuration, layout

Relation between SQL Server 2005 and Volume Shadow Copy services?

Published 19 February 8 2:45 AM | SSQA.net

Until last month I was not aware about Volume Shadow Copy and what is the relation between that service & SQL Server services, so here I would like to give the information in this regard that will discuss SQL Server connection issues that you may...

Filed under: sql server, backup, database, disk, best practices, vss, configuration, volume shadow, sqlwriter