Search results for query: *

Not sure if this is the best Forum, but does anyone know of a way in SQL 2005 (via a script) to monitor for long running transactions. I can see that there is a Perfmon counter that covers this but for whatever reason it is not returning any values? Any help much appreciated. Kind Regards B

Hi All We have deployed 64-bit SQL infrastructure. We have since found that our Monitoring tool (MOM 2005) only has a 32-bit client (which will install on the 64-bit platform in WOW. However the down side is that SQL 2005 only installs its 64-bit performance counters which the MOM Agent cant...

Hi All Im new to vb scripting. Does anyone know how to get a vb script to check for files in a network share? (not a folder). I will alert when there 'x' files and raise a critical alrte when there are 'y' files. The network share is also on a cluster if that makes any difference? The...

Ive an agent that is assigning itself to the wrong site. Is there away of hardcoding Adv cliets to particular site? Any help much appreciated...

Does anyone know of a tool or script that can generate a Vista crash? I need to test Application Exception Monitoring? (also catchs OS crashes) Any help much appreciated. Cheers Andrew

Hi All I need a Script (VB) to check within the 'Webproxylog' table (of the latest 'ISALOG_<yyyymmdd>_web_000' database) to determine if their is a value within the 'ProcessingTime' that has exceeded 30 seconds. Any suggestions \ resources? Any help much appreciated! Kind Regards Andrew

Hi All Is it possible to run a TSQL query (aka 'SELECT * FROM' etc) from within a VB Script. Ive made the following connection from the VB Script, is this the right method of connecting into SQL to then run the TSQL Query? ---------- strDBServerName = "." Set objSQLServer =...

Hi All Im looking to run a script periodically to check the value of certain field within a certain Table. Im new to SQL scripting, so any help much appreciated. The only caveat is that the script has to be a VB Script. Knd Regards A

Hi All Im looking to run a script periodically to check the value of certain fields within certain Tables. Im new to SQL scripting, so any help much appreciated. The only caveat is that the script has to be a VB Script. Knd Regards A

DBCC SHOWCONTIG returned the following info on the table Im concerne3d about. The “Extent Scan Fragmentation” is the value I’m concerned about as it indicates fragmentation. DBCC SHOWCONTIG scanning 'GroomHistory' table... Table: 'GroomHistory' (1253579504); index ID: 0, database ID: 6 TABLE...

Can anyone see an issue with the WMI querybelow? Im looking to monitor for when a particular Process is detected... select * from __InstanceCreationEvent within 30 where TargetInstance ISA ‘win32_process’ and TaregetInstance.Name = ‘notepad.exe’ The above WMI query doesent seem to fire...

Does anyone know of a way of monitoring the execution times of a Stored Procedure? We need to be Alerted whenever a certain Stored Procedure has exceeded a certain time threshold... Any help much appreciated

Does anyone know af a SQL query that I could use to run as a SQL Job that will mean it will run and run. Im looking to test some monitoring scripts to detect for long running SQL jobs. However Im new to scripts and am not sure how to generate a long running script in SQL? Any help much...

Or a little noise at least.... does anyone know how to generate a noise using a script? I need a script to a get an Admins attention whenever we have a particular issue on a console. There are better ways in my opinion but in this case I have no say. Any help much appreciated. Script will...

Im looking for some assistance as to how best to monitor a long-running SQL Jobs via a script? (SQL Agent Job - Process Event Cache) Would this be best achieved with WMI? Any help much appreciated... cheers

Guys Im new to scripting a looking for a simple 'If' query to check if a file is of a particular file extension e.g. Txt ... and then I'll continue with other actions. Any help much appreciated!! Cheers

All I have the below WMI Notification Query on winodws 2000, it runs but sends the resources crazy and appears to be searching through ALL files. Does anyone know how I can modify this to run more efficently? Any help much appreciated!! select * from __InstanceCreationEvent within 10 where...

Any help much appreciated... Heres the objectives: 1. check within a local Folder 2. iterate\step through any Files in that Folder looking for files that are 0 bytes in Size 3. should any file be found to be 0 bytes in size, then generate an Event error in the Windows 2000 Event Log. This is an...

Could someone please assist with my script below. Im pretty certain my use of the IF.. Then is incorrect, Im new to scripting so still trying to get to grips with the Syntax issues. Im trying to check for any File of Size 0 with a specific local folder. Any help much appreicated: Function...

Hi All, Im looking for a script which will allow me to check for any files within a specific (local) folder which are 0 size in bytes. If any are found, too then log an Event. Script needs to be either WMI or VB. Any help much appreciated. Cheers B