Database Activity Monitoring. Any tool known tool for Ms SQL Server 2005 or 2000?

Hi all,

Does anyone knows if exists any tool (from microsoft or other vendor) that allows us to monitor all the activity that is generated in SQL server?

I mean Network appliances or servers that monitor database activity and log activity that is external to the database server, and can generate alerts based on unusual behavior or policy violations. Often rely on a local agent to monitor activity.

I am looking for a tool that not searchs on .log files, or creates triggers.

Any suggestion? any known tool? Pls, send me your answers to lc@.quantumsystem.com

Thanks

You can run Profiler externally, put the output into SQL Tables, set Triggers and Alerts to fire from the data.

And the traces can be conformed and customized in just about any way you desire.

|||

Ok, this is not a possible solution.

We are in a bank, so we need to secure our sql. We need no one to cheat the server or the log files (that is why i asked for a non standard sql procedure).

I want some tool from an external provider.

does anyone knows some tool? Remember i dont want tools that reads the log file, or that just add triggers to databases and tables.

We do not want a hardware based solution too...

I hope you can help me.

Regards,

|||

If you don't want to export to a log file... and you don't want to introduce triggers... what options are left?

Paul A. Mestemaker II
Program Manager
Microsoft SQL Server Manageability
http://blogs.msdn.com/sqlrem/

|||

Paul:

there are some tools (one at least) that runs some monitors (as software services) that allows you to monitor each SQL server, without the option for administrators or DBAs to stop them.

This monitors are connected to central repositories that store all the audited data.

You can audit everything: from select sentences until COPY databases commands, or whatever happens inside the database.

The thing is that i am trying to search , to see if there is another tool, instead the one that we have.

ThankS!

Data type problem

Greetings SSIS friends,

I cast one of my fields from a decimal to an int in my data source (generated from a SQL command). But when I try and map that field to another one of my tables, i get an error saying that I can not cvonvert from decimal to Int32.

Is there any solution which doest require using the derived column or data conversion components?!

Your help would be appreciated.

Can you provide your SQL so that we can look at it? If you are casting to an integer from a decimal in the SQL, SSIS should only see an integer...|||

Hi Phil,

That's what I don't understand.

The SQL is pretty straightforward to be honest.

select
distinct
b.eventid as evt_eventid,
b.meetid as evt_meetid,
cast(h.longname as varchar) as evt_long_name,
cast(h.shortname as varchar) as evt_source_short_name,
b.expstartdate as evt_expstartdate,
b.expstarttime as evt_expstarttime,
b.eventnumber as evt_eventnumber,
b.expertgroup as evt_expertgroup,
b.currentrun as evt_currentrun,
b.enddate as evt_enddate,
b.endtime as evt_endtime,
b.eventstatus as evt_eventstatus,
f.etypeid evt_etypeid,
cast(g.longname as varchar) as evt_type_long_name,
cast(h.longname as varchar) as evt_name,
b.maxplaces as evt_maxplaces,
b.maxpayout as evt_specific_maxpayout,
f.maxpayout as evt_default_type_maxpayout,
b.offdate as evt_offdate,
b.offtime as evt_offtime,
cast(b.callitap as char(1)) as evt_callitap,
cast(isnull(b.maxstake, 0) as int) as evt_maxstake,
b.scoop6leg as evt_scoop6leg,
b.riskoff as evt_riskoff,
b.userofftime as evt_userofftime,
b.delayofftime as evt_delayofftime,
cast(b.suspendliability as int) as evt_suspendliability,
b.termsid as evt_specific_termsid,
i.termsid as evt_default_termsid,
cast(j.longname as varchar) as evt_default_terms,
cast(l.longname as varchar) as specific_evt_terms,
convert(varchar(20), convert(bigint, b.updatetimestamp)) as evt_updatetimestamp
from meetings as a
inner join events as b
on a.meetid = b.meetid
inner join names as c
on a.nameid = c.nameid
inner join EvenType as d
on a.etypeid = d.etypeid
inner join names as e
on d.nameid = e.nameid
inner join EvenType as f
on b.etypeid = f.etypeid
inner join names as g
on f.nameid = g.nameid
inner join names as h
on b.nameid = h.nameid
inner join terms as i
on f.termsid = i.termsid
inner join names as j
on i.nameid = j.nameid
left join terms as k
on b.termsid = k.termsid
left join names as l
on k.nameid = l.nameid
where
convert(varchar(20), convert(bigint, a.updatetimestamp)) > ?
or convert(varchar(20), convert(bigint, b.updatetimestamp)) > ?

order by b.meetid, b.eventid

In SSIS however, it still thinks the column is a decimal.

|||Did you previously have the decimal coming into the source and then later changed the SQL to cast it to an integer?

In the source column mappings, delete the row that corresponds to the column you are working with, and re-map it. Does that help?|||

Hi Phil,

Yes you are right. I unmapped the column and then remaped it and reconfigured my other merge joins and it is now in the data type that I cast it in the SQL code.

Thanks for your help.