Posts
Sort by recent activity
Percentage of database free space
Hi, I would like to set up this metric for a sql 2000 db server, but the query doesn't work, can you please assist. thanks
Job
Hi, i would like to know how to idenitfy the job id or job name by looking at alert, such as Job 0x5A961568FD3BE64CBDCF25A69D3AB7E7. thanks
integrity due alert
Hi,
I am wondering why we get alerts on integrity due on msdb and model db, when dbi_dbccLastKnownGood date field is greater than the 7 days we specify? For example, we have the job start at 2 am, ...
Clock skew alert
Hi,
we are currently on latest version of sql monitor, i would like to know what clock skew alert is about? thanks
Could not find stored procedure 'master..sqbdir'.
Hi We have the latest sql backup pro install on windows 2008 R2 server, but keep failing on the last step: sql backup agent service failed to start, i look at the log
default error in SQLBackupServ...
Point to different data repository issue
Hi, I tried to point the data repository to different server, so i stopped the web service and base service, start the installation file, and point to the new database, it did create the new databa...
Help on the sql log error
Hi WE got on 2.1 yesterday, and today i saw these errors:
Error: 1827, Severity: 16, State: 1.
2011-01-20 08:55:52.68 spid54 CREATE DATABASE or ALTER DATABASE failed because the resulting cumu...
Backup issue
Hi, we are using 6.4 version, and here is the command
-SQL "BACKUP DATABASES [di_repo,etl_stage,parameters_bi,son_db_bi] TO DISK = 'F:\MSSQL.1\MSSQL\Backup\<AUTO>.sqb' WITH ERASEFILES = 5h, ERASEFI...
Help on configure job duration unusual alert
Hi, I got the alert from a job,
Job started at: 19 Jan 2011 2:30 AM
Job ended at: 19 Jan 2011 2:34 AM
Job outcome: Succeeded
Duration: 00:04:03
Baseline duration (median of last 10 runs): 01:03:06
...
SQL process fragment
Hi, on the Release 2, is there a way to show the SQL process fragment
better (complete)? here is what i see: "Command Type: SELECT"
thanks