Foglight for SQL Server 5.7.5.41 - PI Schema Reference Guide

Table 46. ssas_unique_object_fact
Name	Data type	Not Null?	Primary key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
sample_starttime	timestamp with time zone	No	No
sample_endtime	timestamp with time zone	No	No
sample_duration	bigint	No	No
user_name	character varying(256)	No	No
database_name	character varying(256)	No	No
host	character varying(256)	No	No
application	character varying(256)	No	No
command_hash	bigint	No	No
command_type	character varying(256)	No	No
object_id	character varying(256)	No	No
object_id_short_text	character varying(256)	No	No
active_sec	double precision	No	No
reads	double precision	No	No
writes	double precision	No	No
read_kb	double precision	No	No
write_kb	double precision	No	No
rows_scanned	double precision	No	No
rows_returned	double precision	No	No
cpu_time_sec	double precision	No	No
io_wait_sec	double precision	No	No
lock_wait_sec	double precision	No	No
lock_inactive_wait_sec	double precision	No	No
lock_read_wait_sec	double precision	No	No
lock_write_wait_sec	double precision	No	No
lock_commit_shared_wait_sec	double precision	No	No
lock_commit_exclusive_wait_sec	double precision	No	No
lock_commit_abort_wait_sec	double precision	No	No
lock_commit_in_progress_wait_sec	double precision	No	No
lock_invalid_wait_sec	double precision	No	No
idle_wait_sec	double precision	No	No

Table 47. ssas_sessions_stat_fact
Name	Data type	Not Null?	Primary key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
sample_starttime	timestamp with time zone	No	No
sample_endtime	timestamp with time zone	No	No
sample_duration	bigint	No	No
session_spid	integer	No	No
user_name	character varying(256)	No	No
database_name	character varying(256)	No	No
host	character varying(256)	No	No
application	character varying(256)	No	No
command_hash	bigint	No	No
command_type	character varying(256)	No	No
active_sec	double precision	No	No
elapsed_sec	double precision	No	No
used_memory_kb	double precision	No	No
reads	double precision	No	No
writes	double precision	No	No
read_kb	double precision	No	No
write_kb	double precision	No	No
commands_executions	double precision	No	No
cpu_time_sec	double precision	No	No
io_wait_sec	double precision	No	No
memory_wait_sec	double precision	No	No
lock_wait_sec	double precision	No	No
lock_inactive_wait_sec	double precision	No	No
lock_read_wait_sec	double precision	No	No
lock_write_wait_sec	double precision	No	No
lock_commit_shared_wait_sec	double precision	No	No
lock_commit_exclusive_wait_sec	double precision	No	No
lock_commit_abort_wait_sec	double precision	No	No
lock_commit_in_progress_wait_sec	double precision	No	No
lock_invalid_wait_sec	double precision	No	No
remote_wait_sec	double precision	No	No
idle_wait_sec	double precision	No	No

Table 48. ssas_sessions_object_fact
Name	Data type	Not Null?	Primary key?	Default	Comment
instance_key	smallint	No	No
inserted_time	timestamp with time zone	No	No
sample_starttime	timestamp with time zone	No	No
sample_endtime	timestamp with time zone	No	No
sample_duration	bigint	No	No
session_spid	integer	No	No
user_name	character varying(256)	No	No
database_name	character varying(256)	No	No
host	character varying(256)	No	No
application	character varying(256)	No	No
command_hash	bigint	No	No
command_type	character varying(256)	No	No
object_id	character varying(256)	No	No
object_id_short_text	character varying(256)	No	No
active_sec	double precision	No	No
reads	double precision	No	No
writes	double precision	No	No
read_kb	double precision	No	No
write_kb	double precision	No	No
rows_scanned	double precision	No	No
rows_returned	double precision	No	No
cpu_time_sec	double precision	No	No
io_wait_sec	double precision	No	No
lock_wait_sec	double precision	No	No
lock_inactive_wait_sec	double precision	No	No
lock_read_wait_sec	double precision	No	No
lock_write_wait_sec	double precision	No	No
lock_commit_shared_wait_sec	double precision	No	No
lock_commit_exclusive_wait_sec	double precision	No	No
lock_commit_abort_wait_sec	double precision	No	No
lock_commit_in_progress_wait_sec	double precision	No	No
lock_invalid_wait_sec	double precision	No	No
idle_wait_sec	double precision	No	No