Comments
Sort by recent activity
on the custome metric for calculate percentage of database free space as below, doesn't work for sql 2000 database we try to monitor, do you have one could be use? thanks
SELECT (AU.unallocated + AU.unused) * 100 / (AU.reserved + AU.unallocated) AS free_space_pct
FROM (SELECT AU.reserved,
AU.reserved - AU.used AS unused,
CASE WHEN SF.db_size >= AU.reserved THEN (SF.db_size - AU.reserved) ELSE 0 END AS unallocated
FROM (SELECT SUM(CAST(CASE WHEN SF.status & 64 = 0 THEN SF.size ELSE 0 END AS DECIMAL(38, 2))) AS db_size
FROM dbo.sysfiles AS SF) AS SF
CROSS JOIN
(SELECT SUM(CAST(A.total_pages AS DECIMAL(38, 2))) AS reserved,
SUM(CAST(A.used_pages AS DECIMAL(38, 2))) AS used
FROM sys.partitions AS P
INNER JOIN
sys.allocation_units AS A
on A.container_id = P.partition_id) AS AU) AS AU; / comments
on the custome metric for calculate percentage of database free space as below, doesn't work for sql 2000 database we try to monitor, do you have one could be use? thanks
SELECT (AU.unallocated + A...
Yes. the integrity check job start at 2am, and the model and msdb dbi_dbccLastKnownGood field both are 02:01:55.707, and the job completed successfully. but why we still got alert about the due for model and msdb? / comments
Yes. the integrity check job start at 2am, and the model and msdb dbi_dbccLastKnownGood field both are 02:01:55.707, and the job completed successfully. but why we still got alert about the due fo...
Hi,
I do see the servers threw the alert has the same time as the base monitor server. thanks / comments
Hi,
I do see the servers threw the alert has the same time as the base monitor server. thanks
thank you, the component wasn't able to install from the GUI because the 1st post error, now i ran through exe is OK. thanks / comments
thank you, the component wasn't able to install from the GUI because the 1st post error, now i ran through exe is OK. thanks
i don't see this dll exist in bin folder, so how could i add it? / comments
i don't see this dll exist in bin folder, so how could i add it?
after i register the SP, and run the EXEC master..sqbdir 'c:\'
again, i got below error
Msg 17750, Level 16, State 0, Procedure sqbdir, Line 1
Could not load the DLL xp_sqlbackup.dll, or one of the DLLs it references. Reason: 126(The specified module could not be found.). / comments
after i register the SP, and run the EXEC master..sqbdir 'c:\'
again, i got below error
Msg 17750, Level 16, State 0, Procedure sqbdir, Line 1
Could not load the DLL xp_sqlbackup.dll, or one of the...
i have found the answer, thanks / comments
i have found the answer, thanks
it is 2.0.0.3780 / comments
it is 2.0.0.3780
is this still an issue for 2.1? / comments
is this still an issue for 2.1?
Here is the command
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [testdb] TO DISK = ''\\server\F$\MSSQL.1\MSSQL\Backup\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 20H, MAILTO = "test@email.com'', COMPRESSION = 2, THREADCOUNT = 7"'
the version is 1.2. / comments
Here is the command
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [testdb] TO DISK = ''\\server\F$\MSSQL.1\MSSQL\Backup\<AUTO>.sqb'' WITH ERASEFILES_ATSTART = 20H, MAILTO = "test@email.com'', CO...