Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 11_1_1_SQLServer_Базовая информация о сервере
- --Набор скриптов для знакомства с SQL Server
- --https://infostart.ru/1c/articles/1128594/
- ---------------------------------
- -- Базовая информация о сервере
- -- Имена сервера и экземпляра
- Select @@SERVERNAME as [Server\Instance];
- -- версия SQL Server
- Select @@VERSION as SQLServerVersion;
- -- экземпляр SQL Server
- Select @@ServiceName AS ServiceInstance;
- -- Текущая БД (БД, в контексте которой выполняется запрос)
- Select DB_NAME() AS CurrentDB_Name;
- ---------------------------------
- -- Время работы с момента запуска
- SELECT @@Servername AS ServerName ,
- create_date AS ServerStarted ,
- DATEDIFF(s, create_date, GETDATE()) / 86400.0 AS DaysRunning ,
- DATEDIFF(s, create_date, GETDATE()) AS SecondsRunnig
- FROM sys.databases
- WHERE name = 'tempdb';
- ---------------------------------
- -- количество активных соединений с
- SELECT @@Servername AS Server ,
- DB_NAME(database_id) AS DatabaseName ,
- COUNT(database_id) AS Connections ,
- Login_name AS LoginName ,
- MIN(Login_Time) AS Login_Time ,
- MIN(COALESCE(last_request_end_time, last_request_start_time))
- AS Last_Batch
- FROM sys.dm_exec_sessions
- WHERE database_id > 0
- AND DB_NAME(database_id) NOT IN ( 'master', 'msdb' )
- GROUP BY database_id ,
- login_name
- ORDER BY DatabaseName;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement