Performance issue? Anyone seeing any?
randyv
Posts: 166
I just un-installed Monitor 2 for the time being.
I'm going through an ETL to convert our company to a new system.
The new system server was being monitored. All day I've been trying to load data into a target table using the import tool of the vendor's software and it just wasn't going it.
I noticed memory use was very high during this time and I couldn't figure out why.
I decided to just uninstall Monitor 2. I did that (which was on another server for the web and base monitor); then started the batch load again.
The server ran like a scalded dog and finished in 10 minutes!
Anyone have any idea why that would happen? Could it just be coincidence? I don't think so because the batch was the same file. I just killed the load; uninstalled Monitor 2, then restarted the load clean.
Interested in any ideas anyone may have. I'd like to use Monitor 2 as this will be the going forward product, but I can't have it tying up my production servers.
I'm going through an ETL to convert our company to a new system.
The new system server was being monitored. All day I've been trying to load data into a target table using the import tool of the vendor's software and it just wasn't going it.
I noticed memory use was very high during this time and I couldn't figure out why.
I decided to just uninstall Monitor 2. I did that (which was on another server for the web and base monitor); then started the batch load again.
The server ran like a scalded dog and finished in 10 minutes!
Anyone have any idea why that would happen? Could it just be coincidence? I don't think so because the batch was the same file. I just killed the load; uninstalled Monitor 2, then restarted the load clean.
Interested in any ideas anyone may have. I'd like to use Monitor 2 as this will be the going forward product, but I can't have it tying up my production servers.
What we do in life echoes in eternity <><
Randy Volters
Randy Volters
Comments
I'm sorry you've had a performance problem that might be related to SQL Monitor. If you can, please send any information that would help us reproduce or diagnose the problem to daniel.kenyon-jones {AT} red-gate.com .
Cheers,
--
Daniel