Hi,
I’m using this a lot with mssql and in general it works great. But I’ve been noticing that it can affect other queries using the same database… even though I’m doing what I think is a pretty simple query, it seems like it is holding onto the query and perhaps even escalating the locks even though it is a select.
Is this what it going on in the automise code? My iterator might only return say 400 rows and the query is pretty simple… so does it hold onto this query for the life of the iterations?
I have alerts which tell me when a query is taking a long time on a database server and automise scripts frequently come up as long running queries even though the query is as I’ve mentioned very straightforward.
Thanks,
Toni Brown
Sorry this was meant for the automise forum which I’ve now reposted to.
Thanks,
Toni Brown