Prev: Trouble with KB 970315
Next: sql server 2005 triggers
From: april on 23 Dec 2009 13:11
Can someone advise how to monitor SQL 2005 express database size?

Thank you very much!
From: Balaji Thiurvenkataraj on 24 Dec 2009 02:13
Hi, You can use SQL Server Management Studio express to check the database
size.

"april" <april(a)123.com> wrote in message
news:OpMOYt$gKHA.2184(a)TK2MSFTNGP04.phx.gbl...
> Can someone advise how to monitor SQL 2005 express database size?
>
> Thank you very much!

From: Uri Dimant on 24 Dec 2009 04:27
hI
Insert the result of below script into a monitoring table and compare over
tome period
SELECT @@SERVERNAME AS SqlServerName,
db.name AS DatabaseName,
SUM(CASE WHEN syf.groupid = 0 THEN 0 ELSE 8192.0E * syf.size /
1048576.0E END) AS DbSize,
SUM(CASE WHEN syf.groupid = 0 THEN 8192.0E * syf.size /
1048576.0E ELSE 0 END) AS LogSize,
SUM(8192.0E * syf .size / 1048576.0E) AS TotalSize
FROM master..sysdatabases AS db
INNER JOIN master..sysaltfiles AS syf ON syf.[dbid] = db.[dbid]
WHERE db.name NOT IN('distribution', 'master', 'model', 'msdb')
GROUP BY db.name





"april" <april(a)123.com> wrote in message
news:OpMOYt$gKHA.2184(a)TK2MSFTNGP04.phx.gbl...
> Can someone advise how to monitor SQL 2005 express database size?
>
> Thank you very much!


 | 
Pages: 1
Prev: Trouble with KB 970315
Next: sql server 2005 triggers