Browse by Tags

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

SQL Server 2005 BI evaluate and diagnose Analysis Services database performance

Published 18 February 8 3:57 AM | SSQA.net

Performance - one word does it all! You are aware that during the Performance Tuning exercise there are few quick wins within the SQL Server Relational Database Engine such as table statistics for data and indexes. When it comes to Analysis Services Read...

Filed under: sql server, profiler, performance, databases, security, process, sysmon, administrator, Analysis Services, diagnose