For free space monitoring and alert lepide's & redgate having excellent tool

in case you can check them

http://www.sqlservermanagement.net/

http://www.red-gate.com/products/dba/sql-monitor/

Follow the blog in servercentral

http://www.sqlservercentral.com/articles/Miscellaneous/creatingapdffromastoredprocedure/1104/

Also another useful link

http://www.codeproject.com/Articles/19236/Create-data-driven-PDF-on-the-fly-by-using-SQL-ser

The above all mentioned operation can also be performed easily by any sql management software in a very few time

it save lot of time of DBA

http://www.sqlservermanagement.net/

The issue is related to SQL SERVER Performance issue for sure

Increasing memory is one of the best ways to improve SQL Server performance

because more data can be cached in...

The database files can be shrunk manually, either as a group or individually, or the database can be set to shrink automatically at specified intervals.Files are always shrunk from the...

there are few ways with the help of them you can able to reduce your database size

1. Defrag you database

2. Reorganising the indexes

3. Partitioning the database or also table

these...

You can refer the following links to know whether id SCOM is installed on your server or not

[/url]

for alert through email try out any third party tool which will...

Usually, Fragmentation will be caused by 3 reasons.

1. Because of Page Splits. (If the newly inserted records fall in between existing set of records).

2. because of allocation strategy sql internal...

Well being techy You have one more option to get a user defined subject in email notification you can try third party tool also

Try out available tools...

You can also go for a third party tool for the same purpose which will generate a comprehensive report of CPU usage disk space etc which will be helpful to...