Activity overview
Latest activity by johnc650
Ahhh got it now... Did not realize it was running the sqbdata out of master db..
Thanks,
-jfc- / comments
Ahhh got it now... Did not realize it was running the sqbdata out of master db..
Thanks,
-jfc-
How do you connect Multi_script to a CE database.
I was reading this article about reading the windows CE database using multiScript.. http://www.sqlservercentral.com/articles/Backup/61968/.
One thing it did not explain was how to connect to a CE ...
Thanks..
-jfc- / comments
Thanks..
-jfc-
After Upgrading to 5.4 - Timeline is broken.
On the timeline UI the blocks of time for the backups that have run are grey and you can not click on them to get the job info. If I look at the server through the version 5.3 UI everything is fin...
Compare msdb live to backup file fails
I took a backup file of my MSDB db from a few days ago and tried to compare with the live database. When it tries to retrieve the schema it fails with the message, "String was not recognized as a v...
Just got this alert: The log file for database MDS is 136.49MB and has 134.28MB of free space (98.38%). It is recommended to shrink the file to avoid excess wasted space..
But who cares we are talking 135MB here... but I can't set a threshold for this DB or turn off for this DB.. I can only say ignore at the SERVER level or EVERYWHERE... If I ignore on this server the OTHER 35 DBs on it will now NO LONGER monitor for wasted space...CORRECT??
-jfc- / comments
Just got this alert: The log file for database MDS is 136.49MB and has 134.28MB of free space (98.38%). It is recommended to shrink the file to avoid excess wasted space..
But who cares we are talk...
Different levels of thresholds for example on Prod boxes.. CPU
LOW ALERT CPU >= 75%
MED ALERT CPU >= 80
HIGH ALERT CPU >= 90
They show up on the web page as YELLOW, PINK AND RED.
-jfc- / comments
Different levels of thresholds for example on Prod boxes.. CPU
LOW ALERT CPU >= 75%
MED ALERT CPU >= 80
HIGH ALERT CPU >= 90
They show up on the web page as YELLOW, PINK AND RED.
-jfc-
Are thresholds configurable by user?
How are the thresholds set for things like CPU and Free disk drive space.
I have different levels of servers and I don't care if dev uses 95% of disk drive but production should not go above 80%.
S...
SQL Response query shows as long running.
Hey stop monitoring yourselves
Long Running Query 396 Red Gate SQL Response 2/5/2008 1:38:22 PM Unknown OTGJCLARK1 FDOG\myLogin SQL Process List
-jfc-
Check Status of SQL Agent.
You seem to do a lot of job checking.. Why not check the status of sql agent?? The first server I connected to to look at why a couple of jobs did not send emails was because someone had stopped sq...