Archive

Archive for the ‘3rd party’ Category

What Does Confio’s IgniteFree Install on Monitored Instances

January 21st, 2011 9 comments

I was trialling Confio’s IgniteFree software on a development box and wanted to see what exactly gets created when you register an instance for monitoring. Confio states that their installs are “Agentless”, which is true.

I asked Thomas LaRock (blog | twitter) if IgniteFree creates any objects on the server. Answer:

short answer: #ignite does not require creating objects on the monitored instance. –@SQLRockstar (emphasis mine)

What I did discover though, objects do get created on the monitored server.

So what gets created?

USE [master]
GO
/****** Object:  User [DOMAIN\user]    Script Date: 01/21/2011 13:15:11 ******/
CREATE USER [DOMAIN\user] FOR LOGIN [DOMAIN\user] WITH DEFAULT_SCHEMA=[null]
GO
/****** Object:  Schema [DOMAIN\user]    Script Date: 01/21/2011 13:15:10 ******/
CREATE SCHEMA [DOMAIN\user] AUTHORIZATION [DOMAIN\user]
GO
/****** Object:  Table [DOMAIN\user].[ignite_temp]    Script Date: 01/21/2011 13:15:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [DOMAIN\user].[ignite_temp](
	[index_val] [tinyint] NULL,
	[name] [varchar](50) NULL,
	[internal_value] [int] NULL,
	[char_value] [varchar](255) NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
GRANT SELECT ON fn_get_sql to [DOMAIN\user]
GO
GRANT VIEW SERVER STATE to [BUILTIN\Administrators]
GO
Categories: 3rd party, dba Tags: