viveksh47 (11/29/2009)

---

Did you get a resolution. I also ran into same issue. Can't we create DFT and use Script component (Tranformation) between Source and Destination and Source and Destination will...

This is the same thing I'm going to do now, use the DMVs in a job kicked off by a Zabbix alert using the performance counter.

I'll have to experiment with...

And this was on a Dynamics database? Do you know which tables the lock occured and what the trigger was called and does?

When you say 2000 do you mean...

Do you know which trigger and objects this was?

It has to do with a Dynamics database, it keeps getting blocks too frequently which stops all users from working so I'm trying to find out if it's always on...

I've so far set up a trigger in Zabbix (Linux based monitoring tool) to alert me of blocking using the perfmon counter SQL Server General Statistics Processes Blocked, not sure...

Has anyone got any other oppinions on this?

Thanks

BU69

Sorry, that's not really an option for us to buy in third party tools, we don't do enough SSIS development to warrent this, any other ideas anyone?

Thanks, I looked at the code and it the data collection was slightly different from a report that works so I copied the code and replaced it and it now...

I read the article and it was very useful, some of the things like running queries accross multiple servers can now be done in SQL 2008 and some of the...

Is that only in SQL 2008 though? It would interesting to hear more about this, there seems to be so many different ways now, especially with 2008, to administer...

An easier way to distribute monitoring jobs is to use the master and target feature that way you can implement all your jobs or maintenance plans on a central server...

I've just seen on a different server low free pages, what I really need to know is how to troublrshoot this and should I be worried, free pages seem to...

Thank you

I'd seperated tempdb to the number of processes, I can't put them on a seperate spindle due to resources but I'll give this a read and see if I...

I found that earlier but it's the same as the other documents I found and it doesn't explain what to do to troubleshoot this situation which is what I'm trying...