Browse by Tags

SQL Server Clustering - what is the difference between Active/Passive and Active/Active Clustering, which is good for better performance?

Published 18 March 8 4:20 AM | SSQA.net

First part of question is a pure newbie FAQ to know about, and the simple answer would be it is one of the Clustering type you can adopt within your SQL Server environment. To cover on newbie aspect both Active/Passive & Active/Active configuration...

Filed under: sql server, performance, security, clustering, 2005, partition, monitoring, active/passive, parallel execution, performance monitoring, active/active, scalability

SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.

Published 7 March 8 4:54 AM | SSQA.net

Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently...

Filed under: sql server, performance, memory, dmv, windows, 2000, 2005, awe, 64 bit, monitoring, worker threads, paging out, buffers, verison

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

Database Mirroring sys.sp_dbmmonitorupdate stored procedure fails with error "Incorrect syntax near '-'"

Published 12 November 7 3:23 AM | SSQA.net

Recently got stuck with the stored procedure sys.sp_dbmmonitorupdate which is used to monitor the database mirroring session. As usual you could do using the GUI tool, but sometimes using TSQL methods is good enough to see what is happening on your system...

Filed under: sql server, security, bug, database mirroring, error log, 2005, stored procedure, monitoring, hyphen, connect site