1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

SQL 2005 Installation - number of CPUs is not a power of 2

Tuesday, 25 July 2017 04:40

Today I encountered an issue while installing SQL 2005, thought of sharing with you guys about the issue and steps taken to resolve the issue.

I was trying to install SQL 2005 in one of the clustered server, the installation was get failed while installing the SQL Database services. I was getting the below error message :

Read more...

Database Mail - Queued but not delivered

Tuesday, 25 July 2017 04:40

Database Mail was not getting delivered after applying service pack 4 in MS SQL Server

Step 1 :

Read more...

A significant part of sql server process memory has been paged out

Tuesday, 25 July 2017 04:40

We have recently encountered an incident with below error message in one of the most critical production system, upon analysis, it was found that considerable amount of memory reserved by SQL Memory was trimmed due to lack of physical memory. During the trimming operation, for about 5 minutes, overall SAP system performance was poor and all the end users were having very high response time.

 

Read more...

Deadlock Monitoring Script

Tuesday, 25 July 2017 04:40

 

Below script will help you to effectively monitor the deadlock; the same will also send out the alerts when the deadlock is identified. Please configure database mail according to article http://www.basisondemand.com/mss/configure_database_mail_sp_send_dbmail, only then this script will be able to send out the alerts, else the job will fail.

 

Read more...

SQL Service Pack Upgrade Issues

Tuesday, 25 July 2017 04:40

Today I had to deal with many number of issues those occurred while performing SQL Service Pack 4 Upgrade in MSCS environment, the issues were absolutely strange (at least to me), there were no structural solution given either by SAP / Microsoft, hence I had to go with my own way of identifying the root cause.  I have listed down all of the issues and the possible solutions below,  I am sure this will help you one or the other day when you attempt to implement SQL Service Packs in MSCS environment.

 

Issue # 1 : Unable to install windows installer MSP file

 

Solution :  Stop the installation process, kill all the hotfix.exe and  related processes (msiexec) those are running in both the nodes. If needed, restart both the nodes to clear the hanging installation processes.

Issue # 2 :  Installation in Passive Node gets stuck and runs for a very long time, below kind of message can be seen in the log, but nothing more.

 

 

Solution : Killed msiexec process on the passive node (when the installation is running), then it will be alright (believe me, it worked very well for me)

 

Issue # 3 : MSP Error 29512, SQL Server Setup was unable add user to local group

Solution : Check the user which is used to run the SQL services is added to the cluster group mentioned in the error message, if not add the user to the user  group related to the cluster. If that is something not doable, then change the service to run with the user that is maintained in the cluster group mentioned in the error (the same should be done using the configuration manager and not directly in the services.msc)

 

 

Issue # 4 : sqlsrvres.dll is being held in use by the following process name : resrcmon

 

Solution : You may ignore the error message as this is just a warning, this is really not something to be worried about, if you still think that there is a problem due to the file being blocked, then  uncheck the “Run this resource in a separate resource monitor” in the cluster configuration for the services related to SQL server.

 

{fcomment} {flike}

Share

SQL Service Pack Upgrade Issues

MSSQL