Browse by Tags

SQL Server 2005 Performance Dashboard

Published 12 June 8 6:25 AM | SSQA.net

I've had one or two requests recently to set up the Performance Dashboard reports on SQL Server so I've created this blog post to step through the process. Firstly, the Performance Dashboard was created to allow customers and support engineers...

Filed under: sql server, performance, tools, 2005

SQL Server High Number of User Connections found on PERFMON, how to resolve it?

Published 3 June 8 3:7 AM | SSQA.net

I was working with one of the user project to monitor the Performance Audit of their SQL Server estate. One SQL instance among the SQL farm is very important to their day-to-day business and cannot sustain even 5 minutes of downtime which is termed as...

Filed under: sql server, performance, sysmon, 2000, 2005, high cpu, perflib, activity, user connections, mars

A query that references a nondeterministic user-defined function may run slower in SQL Server 2005 than in SQL Server 2000

Published 12 May 8 1:43 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications A query that references a nondeterministic...

Filed under: sql server, performance, query, kba, 2000, 2005, slow

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

BI Virtual labs on MSDN - specific to data mining and top 10 classed in Tech-ed.

Published 26 February 8 4:45 AM | SSQA.net

As blogged here before Virtual Labs are very handy for the new users and existing professionals to test out new features without disturbing their own platform. In this scenario Microsoft events are helping the users by providing access to their virtual...

Filed under: sql server, performance, microsoft, technet, data mining, version, virtual, labs, 2005, loading

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

Best way to deploy SQL Server 2005 with SAN

Published 28 January 8 2:1 AM | SSQA.net

If it is a first time you are deploying the SQL Server 2005 on a SAN, then there are few things you need to be considered that will be raised by installations that are either deploying SQL Server for the first time or are upgrading to SAN from direct...

Filed under: sql server, performance, tools, 2005, san, best practice, raid, hardware, configuration, benchmarking, downloads, iometer, deployment, sqlio

SQL Server Analysis Services slicing and dicing

Published 27 January 8 6:8 AM | SSQA.net

I was going through Books Online in learning the concepts of slicing of data within Analysis Services for the new project that is upcoming, all these years I have basic knowledge of SSAS and with latest available features in SQL Server 2005 Analysis Services...

Filed under: sql server, performance, data mining, 2005, Analysis Services, slicing

SQL Server 2008 Data Compression, what it is - how does it work?

Published 3 December 7 7:54 AM | SSQA.net

As you know data compression facility is added onto the SQL Server 2008 version, though this is not a new feature and I would call it as an enhanced feature in SQL Server. This subject of data compression has already been introduced in SQL Server 2005...

Filed under: sql server, performance, microsoft, blogs, security, 2008, ctp, data capture, 2005, compress, data compression

FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005

Published 24 September 7 1:2 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Standard Edition, SQL Server 2005 Enterprise Edition & SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX...

Filed under: application, sql server, performance, replication, kba, 2005, memory leak, terminate, activex, initialize