Home / Microsoft SQL Server

Microsoft SQL Server

Query to check MS SQL restoration/Backup percentage

We can use below select command to check backup/restoration percentage.  We can execute this query when MS SQL Backup or restoration is in progress. Also this query will show the processes which are running in DB (Backup, Restore, rebuild, compression) =========================================== SELECT command, s.text, start_time, percent_complete, CAST(((DATEDIFF(s,start_time,GetDate()))/3600) as varchar) + …

Read More »

Video Articles for SAP NW on SQL Server

You probably have heard that SAP Product Support is creating Knowledge Base Articles with embedded videos. Our Product Support team is now working on to create articles with videos to help customers and partners on how to perform specific tasks, troubleshoot, etc. We added recently a specific wiki page in …

Read More »

New SCN Wiki – SAP on SQL Server

Hi everyone! I’m very proud to announce that as of November 1st, 2015 the new SCN Wiki SAP on SQL Server is available for community access in the following address: http://wiki.scn.sap.com/wiki/display/SAPSQL/SAP+on+SQL+Server Make sure to bookmark this in your favorite web browser! What is SAP on SQL Server SCN Wiki? SAP …

Read More »

SAP Startup failing/hanging with SQL Server

Hi everyone, Months ago I worked with some SAP customers where they had some problems to startup their SAP Netweaver system after implementing AlwaysOn feature on SQL Server. Basically the problem was strdbs.cmd script in yellow status and never starting the disp+work. This also affects the strdbsj2ee.cmd script during the …

Read More »

Analyzing and Identifying Database Corruptions

This blog post will cover some part of this topic which seems to be the most painful and unpredictable  situation: database corruption. They’re mostly physical inconsistencies, associated with storage and raid controllers (physical devices), drivers, software controllers, etc. Database corruptions can happen at any time due to many factors, but …

Read More »

Bad I/O Performance on SQL Server?

1. Check the Data Cache Hit Ratio of your database! One of the most important things to configure is the memory for SQL Server. If you observe a bad database performance and a low data cache hit ratio for a long time during database load, you should increase the memory …

Read More »

Are you facing disconnections?

Are you facing disconnections (sql/database error 0, 11, 121, -1 or 10054) with your SAP system? The following points might help you to solve this issue! 🙂 1. Refer to Dale’s presentation: Analyzing Network Errors on SQL Server. 2. Follow all the steps in the SAP KBA 1478133. 3. Some …

Read More »

SQL Server Configuration: Pre-SAP Installation

You’re back from your coffee break, and your SQL Server 2012 installation has completed successfully. What next? You’re ready to install your SAP application now, right? Not quite yet. There are a few configuration and housekeeping steps you should take before going further. Note: many of these steps can also …

Read More »

SQL Server 2012 Installation Recommendations

SQL Server 2012 is relatively easy to install, and the installation guide from SAP is very clear. However, there are a few guidelines from my own experience that may be of benefit to others performing this installation for the first time. The following example assumes an installation on Windows Server …

Read More »

Transaction Log Growing Continuously..?

Problem: Transaction Log Growing Continuously System: ERP (XYZ) Solution: First take all types of Backups (Full Db, Differential, master, model and Transaction log), Put the DB recovery mode to SIMPLE/FULL Query: ALTER DATABASE [mydatabase] SET RECOVERY SIMPLE/FULL To Know the Reuse_wait_reason of each DB Query:  select <name>, recovery_model_desc, log_reuse_wait_desc from …

Read More »