Use the script below to find the tcp port number that the SQL Server is listening on.
SELECT local_tcp_port FROM sys.dm_exec_connections WHERE session_id = @@SPID GO
No comments
Month: August 2017
SQL Server – Get Backupset Records
The script below retrieves the backupset records. A backup set contains the backup from a single, successful backup operation. RESTORE, RESTORE FILELISTONLY, RESTORE HEADERONLY, and RESTORE VERIFYONLY statements operate on a single backup set within the media set on the specified backup device or devices.
USE msdb ; SELECT backup_start_date , backup_finish_date, CAST(ROUND ((backup_size / 1024 / 1024), 0, 1) AS DECIMAL (18,0)) AS Backup_Size_MB , recovery_model, [type] FROM dbo.backupset WHERE database_name = 'RBD_DB' ORDER BY backup_start_date DESC /* Backup type. Can be: D = Database I = Differential database L = Log F = File or filegroup G =Differential file P = Partial Q = Differential partial Can be NULL. Reference: https://technet.microsoft.com/en-us/library/ms186299(v=sql.110).aspx */
ORACLE – Find Out If An Instance Is Running
ORACLE – Investigate the Memory Structures of the Instance
Below is a script to show the current, maximum and minimum sizes of the SGA components that can be dynamically resized.
SELECT component, current_size, min_size, max_size FROM v$sga_dynamic_components;
Execute the script below to Determine how much memory has been, and is currently, allocated to program global areas
SELECT
name,
value
FROM
v$pgastat
WHERE
name IN ('maximum PGA allocated','total PGA allocated');