One of our client had such requirement to cater a load balancing for their application and needed to upgrade to higher versions of SQL Server & Operating systems. The current setup at their end is a SQL Server 2000 Active/Passive Cluster and the transactions
Read More...
Based on this Troubleshoot a process (SPID) using tools & TSQL queries blog post I have been asked to provide same information within SQL Server 2000 version, as that talks about SQL 2005 version specific. Within SQL 2000 to troubleshoot further about
Read More...
Microsoft Licensing methods for SQL Server is always a mystery! Though visiting HOWTOBUY says what type of license choose but nothing much to understand. Scalable link explains bit more than that page. Still I have to search for a quest on how many processor
Read More...
I came across interesting post in SSP looking for a way of automating the Database Tuning Advisor tool of SQL Server 2005 with the help of SQLServer Agent. As the originator looking to schedule it on a regular basis to scan a trace (Profiler) file and
Read More...
I/O means Input and Output in simple terms, but in SQL Server world it has a vast significance to handle for performance and tuning. Here are few I/O basics chapters that will help the new users in SQL Server to understand : http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/sqlIObasics.mspx
Read More...