Advertisement
chadbaldwin

Splunk - SQL Server Index Usage Raw event

Sep 15th, 2023
238
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
JSON 0.58 KB | None | 0 0
  1. {
  2.   "DatabaseName": "MyDatabase",
  3.   "SQLServerStartTimeUTC": "2023-08-01T04:03:24.3",
  4.   "ObjectSchemaName": "dbo",
  5.   "ObjectName": "SomeTableName",
  6.   "IndexName": "IX_SomeTableName",
  7.   "ObjectType": "USER_TABLE",
  8.   "ObjectCreateDate": "2020-03-07T09:57:34.657",
  9.   "IndexType": "NONCLUSTERED",
  10.   "IsUnique": false,
  11.   "IsUniqueConstraint": false,
  12.   "IsPrimaryKey": false,
  13.   "IsDisabled": false,
  14.   "HasFilter": false,
  15.   "UserSeeksCount": 198,
  16.   "UserScansCount": 0,
  17.   "UserLookupsCount": 0,
  18.   "UserUpdatesCount": 87876,
  19.   "EstimatedIndexSizeKB": 19128,
  20.   "IndexRowCount": 1158545
  21. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement