Comments
Sort by recent activity
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 ...
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...
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...
Hi Chris,
If I could make one huge suggestion in regards to emails... We don't want to broadcast any internal server information to the Internet via email, but it would be nice to have a customized email notification that could be sent to my cell phone when certain alerts come through or possibly HIGH alerts that just says somethings up and check the server with no specific information. Even if there's some way to script the entier body and subject of the email or at the very least give the option to spawn an application or something other than an email on alert so a home brew app could run and do other tasks when something's amiss.
Just a suggestion. / comments
Hi Chris,
If I could make one huge suggestion in regards to emails... We don't want to broadcast any internal server information to the Internet via email, but it would be nice to have a customize...