Purpose
It is very important to monitor the transaction log size of SQL Server. If SQL Server runs out of log space the system will come to a standstill. The log space is released when a log backup is performed. But the space is only made available u...
Purpose
Deadlocks can occur in any SQL Server multiuser application. The occurrences of deadlocks are a problem of the application. It is not a SQL Server problem. SQL Server and SAP provide tools to detect, monitor and analyze the deadlocks. But in ...
Purpose of the tool
Do you manage a large number of SQL Server instances running many different applications? Do they encounter critical performance problems from time to time? If that's the case then this new DBACOCKPIT feature may be helpful to y...
Hello Uma, sorry but SAP can't support this option. This is not tested by our validation team and any access to MySQL via DSN/ODBC can produce unpredictable results.The only recommendation I can make is to first transfer the data from MySQL to a dat...
Due to the architecture mis-match this check (sap_mon_sqlsetup) did report a problem, even though there is no discrepancy in the patch level of the executables or dlls. There is a note about this: 1331123.You can apply the basis support package, or j...
Ok Ken, sorry I misunderstood, you were doing it the way I suggested. So the files (the .mdf file) must have been corrupted somehow during the handling, maybe the detaching of your temporary device etc.Possibly it could help to temporarily detaching...
Hi Ken,you are right, it's not the average situation :-).Ok but it should work. Just remember:1. copy the files of the source system while either SQL Server is shutdown or the database is detached. I assume you're only copying the files of one data...
Hi Petra,this is very mysterious. Do you see nothing in the DB collector Time Series tab, even when picking the value group "Absolutely Everything" in the dropdown box? (and a longer time period)? I would suggest to open a customer message and let ...
