Browse by Tags

SQL Server - Have you observed DBCC SHRINKFILE operation performance, on huge databases?

Published 25 April 8 3:30 AM | SSQA.net

In general it is not a best practice to perform SHRINK database operation on a production server, atleast regularly! Sometimes it may be compulsory to keep them sized in order to ensure the disk storage is not compromised for any sudden changes to databases...

Filed under: sql server, indexes, memory, databases, cache, cpu, monitoring, operating system, huge, dbcc shrinkfile

SQL Server license with multi-core CPU technology, confusing concepts?

Published 20 February 8 2:47 AM | SSQA.net

How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...

Filed under: sql server, performance, microsoft, version, article, license, 2005, cpu, monitoring, administrator, value, costing

SQL Server licensing with having multi-core CPU technology, confusing concepts?

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

How many SQL Server licenses you need to fix the number of CPUs on the server? The answer it depends on the number! Well having hyper-threading (i.e. multiple threads execute on a single physical CPU appearing as 2 logical CPUs) and dual-core technology...

Filed under: sql server, performance, microsoft, version, article, license, 2005, cpu, monitoring, administrator, value, costing