SQLServerMonitoringSolution/performancecounters_tbl.sql at master · ash3rr/SQLServerMonitoringSolution · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
USE [DBATools]
GO

/****** Object:  Table [dbo].[performancecounters]    Script Date: 20.09.2022 12:35:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[performancecounters](
	[BufferCacheHitRatio] [numeric](38, 13) NULL,
	[PageReadsPerSec] [bigint] NULL,
	[PageWritesPerSecond] [bigint] NULL,
	[UserConnections] [bigint] NULL,
	[PageLifeExpectency] [bigint] NULL,
	[CheckpointPagesPerSecond] [bigint] NULL,
	[LazyWritesPerSecond] [bigint] NULL,
	[FreeSpaceInTempdbKB] [bigint] NULL,
	[BatchRequestsPerSecond] [bigint] NULL,
	[SQLCompilationsPerSecond] [bigint] NULL,
	[SQLReCompilationsPerSecond] [bigint] NULL,
	[Target Server Memory (KB)] [bigint] NULL,
	[Total Server Memory (KB)] [bigint] NULL,
	[MeasurementTime] [datetime] NOT NULL,
	[AvgTaskCount] [int] NULL,
	[AvgRunnableTaskCount] [int] NULL,
	[AvgPendingDiskIOCount] [int] NULL,
	[PercentSignalWait] [bigint] NULL,
	[PageLookupsPerSecond] [bigint] NULL,
	[TransactionsPerSecond] [bigint] NULL,
	[MemoryGrantsPending] [bigint] NULL,
	[MeasurementDate] [date] NULL
) ON [PRIMARY]
GO