Activity overview
Latest activity by samalex
Priya,
As always thanks for the quick response, and this will help tremendously.
As for UTC vs CST I definitely see the reasons to save Datetime fields in UTC, but for reporting I need them in CST given all our other reports use CST. I'm actually working on a function now to convert UTC to any given timezone offset based on the DST standards, even taking into account the difference in standards before 2007. It's definitely some funky logic to work out, but once it's working I'll just use this in the report for the Datetime fields. I just thought maybe you guys had another simpler suggestion...
Take care --
Sam / comments
Priya,
As always thanks for the quick response, and this will help tremendously.
As for UTC vs CST I definitely see the reasons to save Datetime fields in UTC, but for reporting I need them in CST ...
Questions about SQL Monitor report (SQL Agent Job Summary)
First thing, thanks to whoever created the SSRS reports for SQL Monitor at Red Gate... these are exactly what I needed, especially the SQL Agent Job Summary report. I do however have some question...
Thanks Priya... After posting my question I went through the menus and found exactly how to do this. I was afraid the licensing wouldn't allow setting-up more than one server, but you guys did great making it flexible.
Take care --
Sam / comments
Thanks Priya... After posting my question I went through the menus and found exactly how to do this. I was afraid the licensing wouldn't allow setting-up more than one server, but you guys did gre...
Moving monitoring software to another SQL Server temporarily
We're running SQL Monitor 2.2.0.260 and we're licensed for two monitored servers, but we need to temporarily monitor a third server for just a short amount of time. Is it possible to disable one o...
Chris,
I've sent everything to you via Email. Let me know if you find anything that might help us.
Take care --
Sam / comments
Chris,
I've sent everything to you via Email. Let me know if you find anything that might help us.
Take care --
Sam
Hi Chris,
Under Configuration > Monitored servers it shows both servers are Monitoring and Connected (green checks) and no errors are listed under the Show Log. I'll send you the Logs via PM though for the SQL 2000 server if that might show what's happening.
And our network guys did verify the path does exist on the SQL 2000 server, so we are good there.
Thanks -
Sam / comments
Hi Chris,
Under Configuration > Monitored servers it shows both servers are Monitoring and Connected (green checks) and no errors are listed under the Show Log. I'll send you the Logs via PM thoug...
Chris,
I uninstalled both SQL Response applications and now here's the output of the query:
SELECT * FROM :: fn_trace_getinfo(DEFAULT)
traceid property value
1 1 2
1 2 C:\Program Files\Microsoft SQL Server\MSSQL\LOG\20101116172411-[servername]-MONITOR
1 3 250
1 4 2010-11-16 11:30:11.400
1 5 1
Problem though is this path doesn't exist on our server. Where can I change it so it's using E: instead of C: since our C: is limited on space. I bet this is the problem.
EDIT:: Nevermind, I was looking for this path on the server running SQL Monitor not the Database Server itself .. my mistake. I'll need to get our network guys to verify the path exists on the database server.
Thanks --
Sam / comments
Chris,
I uninstalled both SQL Response applications and now here's the output of the query:
SELECT * FROM :: fn_trace_getinfo(DEFAULT)
traceid property value
1 1 2
1 2 C:\Program Files\Microsoft SQ...
Hi Chris,
I sent the output of the query via PM. Looks like both SQL Response and SQL monitor are both listed. Should I uninstall or remove SQL Response?
Thanks,
Sam / comments
Hi Chris,
I sent the output of the query via PM. Looks like both SQL Response and SQL monitor are both listed. Should I uninstall or remove SQL Response?
Thanks,
Sam
On our SQL 2000 box I just had a Long-running query alert, and as usual there was no Profiles Trace, but it did show this:
SQL process fragment
Command Type: AWAITING COMMAND
I'm not sure if this'll help identify the problem.
Thanks --
Sam / comments
On our SQL 2000 box I just had a Long-running query alert, and as usual there was no Profiles Trace, but it did show this:
SQL process fragment
Command Type: AWAITING COMMAND
I'm not sure if this'l...
No Profile Trace on SQL 2000 Database
We have SQL Monitor tracking two databases, one being SQL 2005 and the other SQL 2000. I have Profile Traces enabled on both, but for alerts on our SQL 2000 server there's never any trace informat...