SQL Smart Solutions

Search This Blog

SCRIPT: How to check how many SQL instances are installed on the Windows Server?

on July 03, 2024

Get link
Facebook
X
Pinterest
Email
Other Apps

Get-Service | Where-Object {$_.DisplayName -like "SQL Server (*"}

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Script: How to get SQL Server messages from Windows Event Viewer?

$startDate = '2024-08-10' $endDate = '2024-08-11' Get-EventLog -LogName "application" ` | Where-Object {$_.source -like "*SQL*" -and $_.TimeGenerated -ge $startDate -and $_.TimeGenerated -lt $endDate } ` | Select-Object source, EntryType, TimeGenerated, Message

SCRIPT: Check implicit transactions

SELECT trans . session_id AS [SESSION ID] , ESes . host_name AS [HOST NAME] , login_name AS [Login NAME] , trans . transaction_id AS [TRANSACTION ID] , tas . name AS [TRANSACTION NAME] , tas . transaction_begin_time AS [TRANSACTION BEGIN TIME] , tds . database_id AS [DATABASE ID] , DBs . name AS [DATABASE NAME] FROM sys . dm_tran_active_transactions tas JOIN sys . dm_tran_session_transactions trans ON ( trans . transaction_id = tas . transaction_id ) LEFT OUTER JOIN sys . dm_tran_database_transactions tds ON ( tas . transaction_id = tds . transaction_id ) LEFT OUTER JOIN sys . databases AS DBs ON tds . database_id = DBs . database_id LEFT OUTER JOIN sys . dm_exec_sessions AS ESes ON trans . session_id = ESes . session_id WHERE ESes . session_id IS NOT NULL

SCRIPT: How to check SSRS and SSIS usage?

SSIS: --SQL jobs which executes SSIS packages SELECT j . name , js . last_run_date , js . last_run_time , js . command FROM msdb . dbo . sysjobsteps js INNER JOIN msdb . dbo . sysjobs j ON js . job_id = j . job_id WHERE subsystem = 'SSIS' AND j . category_id <> 3 ORDER BY js . last_run_date DESC , js . last_run_time DESC -- All SSRS packages SELECT PCK . name AS PackageName , PCK . [description] AS [Description] , FLD . foldername AS FolderName , CASE PCK . paackagetype WHEN 0 THEN 'Default client' WHEN 1 THEN 'I/O Wizard' WHEN 2 THEN 'DTS Designer' ...

SCRIPT: How to check how many SQL instances are installed on the Windows Server?

Comments

Post a Comment