ÿþ<!DOCTYPE html> <html lang="en" dir="ltr"> <head> <title>virtualDBA | eleven27</title> <meta name="author" content="eleven27"> <meta name="description" content="virtualDBA - Fully Automated Database Maintenance, Monitoring and Auditing System for SQL Server 2005/2008"> <meta name="keywords" content="virtualDBA, eleven27, virtual database, free virtual database, free database maintenance, dba tools, database tools, free database tools, database, maintenance, monitoring, auditing, automated database, virtual database, virtual dba, virtualdba, automated monitoring, automated auditing, SQL Server, SQLServer, sql server, automated, automation, dba, DBA, sql 2000, sql 2005"> <meta name="robots" content="index,follow"> <meta name="revisit-after" content="3"> <link type="text/css" rel="stylesheet" href="http://www.virtualdba.ca/floatbox/floatbox.css" /> <script type="text/javascript" src="http://www.virtualdba.ca/floatbox/floatbox.js"></script> <script type="text/javascript"> fbPageOptions = { colorHTML: 'blue' }; </script> <style> a:link, a:visited {text-decoration: none}, a:active {text-decoration: none} </style> <style type="text/css"> table { border: 0px solid #000000; font-family: helvetica; font-size: 10pt; } th { border: 1px solid #000000; background-color: #488AC7 } table.inner { border: 0px solid #000000; font-family: helvetica; font-size: 10pt; padding: 5; spacing: 10; } table.shadow { align: center; font-family: helvetica; font-size: 10pt; } table.shadow-sd { align: center; font-family: helvetica; font-size: 10pt; background-color: #EEEEFF } td.shadow-sd-topLeft { width: 20px; height: 41px; background-image: url("http://static.virtualdba.ca/img/png/sd_TL.png") } td.shadow-sd-top { height: 41px; background-image: url("http://static.virtualdba.ca/img/png/sd_T.png") } td.shadow-sd-topRight { width: 20px; height: 41px; background-image: url("http://static.virtualdba.ca/img/png/sd_TR.png") } td.shadow-sd-left { width: 20px; background-image: url("http://static.virtualdba.ca/img/png/sd_L.png") } td.shadow-sd-right { width: 20px; background-image: url("http://static.virtualdba.ca/img/png/sd_R.png") } td.shadow-sd-bottomLeft { width: 20px; height: 30px; background-image: url("http://static.virtualdba.ca/img/png/sd_BL.png") } td.shadow-sd-bottom { height: 30px; background-image: url("http://static.virtualdba.ca/img/png/sd_B.png") } td.shadow-sd-bottomRight { width: 20px; height: 30px; background-image: url("http://static.virtualdba.ca/img/png/sd_BRb.png") } td.shadow-top { height: 41px; background-image: url("http://static.virtualdba.ca/img/png/Tb.png") } td.shadow-topRight { width: 20px; height: 41px; background-image: url("http://static.virtualdba.ca/img/png/TRb.png") } td.shadow-ctop { height: 16px; background-image: url("http://static.virtualdba.ca/img/png/cT.png") } td.shadow-ctopRight { width: 16px; height: 16px; background-image: url("http://static.virtualdba.ca/img/png/cTRb.png") } td.shadow-right { width: 20px; background-image: url("http://static.virtualdba.ca/img/png/Rb.png") } td.shadow-bottomRight { width: 20px; height: 30px; background-image: url("http://static.virtualdba.ca/img/png/BRb.png") } td.shadow-bottom { height: 30px; background-image: url("http://static.virtualdba.ca/img/png/B.png") } td.shadow-bottomLeft { width: 20px; height: 30px; background-image: url("http://static.virtualdba.ca/img/png/BL.png") } td.shadow-left { width: 20px; background-image: url("http://static.virtualdba.ca/img/png/L.png") } td.shadow-topLeft { width: 20px; height: 41px; background-image: url("http://static.virtualdba.ca/img/png/TLb.png") } td.shadow-ctopLeft { width: 16px; height: 16px; background-image: url("http://static.virtualdba.ca/img/png/cTL.png") } td.shadow-center { align: center; } body { margin: 0; padding: 0; } </style> </head> <body> <table width="100%" bgcolor="silver" cellpadding="0" cellspacing="0"> <tr border="0"> <td background="http://static.virtualdba.ca/img/png/hdrt.png" height="28px" align="right" valign="middle"> <img src="http://static.virtualdba.ca/img/png/hdre27.png" border="0">&#160&#160&#160 </td> </tr> </table> <br> <!--Header--> <!--Main--> <table width="95%" border="0" cellspacing="0" cellpadding="0" align="center"> <tr> <!--Left--> <td valign="top" width="12%"> <table width="100%" class="shadow-sd" border="0" cellspacing="0" cellpadding="0" valign="top" align="center"> <tr> <td class="shadow-sd-topLeft"></td> <td class="shadow-sd-top"></td> <td class="shadow-sd-topRight"></td> </tr> <tr> <td class="shadow-sd-left"></td> <td class="shadow-sd-center" valign="top"> <center><a href="http://www.virtualdba.ca/main/" class="fbTooltip" data-fb-tooltip="source:#ttip_prod attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" border="0"></a></center> <center><a href="http://www.virtualdba.ca/main/"><font size="2" color="silver"><strong>the.<strong></font><font size="2" color="#000000"><strong>product</strong></font></a></center> <br> <center><a href="http://www.virtualdba.ca/main/support/" class="fbTooltip" data-fb-tooltip="source:#ttip_supp attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/suppt.png" border="0"></a></center> <center><a href="http://www.virtualdba.ca/main/support/"><font size="2" color="silver"><strong>the.<strong></font><font size="2" color="#000000"><strong>support</strong></font></a></center> <br> <center><a href="http://blog.virtualdba.ca" class="fbTooltip" data-fb-tooltip="source:#ttip_blog attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/blog.png" border="0"></a></center> <center><a href="http://blog.virtualdba.ca"><font size="2" color="silver"><strong>the.<strong></font><font size="2" color="#000000"><strong>blog</strong></font></a></center> <br> <center><a href="http://forums.virtualdba.ca" class="fbTooltip" data-fb-tooltip="source:#ttip_comm attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/comm.png" border="0"></a></center> <center><a href="http://forums.virtualdba.ca" class="fbTooltip" data-fb-tooltip="source:#ttip_comm attachToHost:true" alt=""><font size="2" color="silver"><strong>the.<strong></font><font size="2" color="#000000"><strong>forums</strong></font></a></center> <br> <center><a href="http://www.virtualdba.ca/main/about/" class="fbTooltip" data-fb-tooltip="source:#ttip_about attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/cmp.png" border="0"></a></center> <center><a href="http://www.virtualdba.ca/main/about/"><font size="2" color="silver"><strong>the.<strong></font><font size="2" color="#000000"><strong>company</strong></font></a></center> <br> </td> <td class="shadow-sd-right"></td> </tr> <tr> <td class="shadow-sd-bottomLeft"></td> <td class="shadow-sd-bottom"></td> <td class="shadow-sd-bottomRight"></td> </tr> <tr> <td class="shadow-sd-topLeft"></td> <td class="shadow-sd-top"></td> <td class="shadow-sd-topRight"></td> </tr> <tr> <td class="shadow-sd-left"></td> <td class="shadow-sd-center" valign="top"> <center><a href="http://forums.virtualdba.ca/index.php?board=21.0" class="fbTooltip" data-fb-tooltip="source:#ttip_vault attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/vault.png" border="0"></a></center> <center><a href="http://forums.virtualdba.ca/index.php?board=21.0" class="fbTooltip" data-fb-tooltip="source:#ttip_vault attachToHost:true" alt=""><font size="2" color="silver"><strong>the.<strong></font><font size="2" color="#000000"><strong>library</strong></font></a></center> </td> <td class="shadow-sd-right"></td> </tr> <tr> <td class="shadow-sd-bottomLeft"></td> <td class="shadow-sd-bottom"></td> <td class="shadow-sd-bottomRight"></td> </tr> <tr> <td class="shadow-sd-topLeft"></td> <td class="shadow-sd-top"></td> <td class="shadow-sd-topRight"></td> </tr> <tr> <td class="shadow-sd-left"></td> <td class="shadow-sd-center" valign="top"> <br> <center><a href="http://www.microsoft.com/sqlserver/2008/en/us/default.aspx"><img src="http://static.virtualdba.ca/img/png/sql_ad.png" border="0"></a></center> <br> </td> <td class="shadow-sd-right"></td> </tr> <tr> <td class="shadow-sd-bottomLeft"></td> <td class="shadow-sd-bottom"></td> <td class="shadow-sd-bottomRight"></td> </tr> </table> </td> <!--Center--> <td valign="top" width="42%"b> <table width="100%" class="shadow" border="0" cellspacing="0" cellpadding="0" valign="top"> <tr> <td class="shadow-topLeft"></td> <td class="shadow-top"></td> <td class="shadow-topRight"></td> </tr> <tr> <td class="shadow-left"></td> <td class="shadow-center" valign="top"> <table cellpadding="10"><tr><td> <br> <font size="4" color="silver"><strong>the.</strong></font><font size="4" color="#0066cc"><strong>faq</strong></font> <br> <br> <strong>This section is being moved to our <a href="http://forums.virtualdba.ca"><font color="#0066cc">online forums. </font></a> Please feel free to register and contribute your feedback to the virtualDBA project.</strong> <br> <br> <font color="silver"> <a href="#installation">Installation</a> <br> <a href="#configuratiob">Configuration</a> <br> <a href="#maintenance">Maintenance</a> <br> <a href="#audit">Audit</a> <br> <a href="#reporting">Reporting</a> <br> <a href="#system">System</a> </font> <br> <br> <hr> <br> <a name="installation"><font size="3" color="silver"><strong>the.</strong></font><font size="3" color="#0066cc"><strong>installation</strong></font></a> <br> <br> <font size="2"> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I receive the error "virtualDBA installation failed. View the setup log [vw_adm_setup_log] for more details." when I run the setup procedure. How do I get the installation to work?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> In SQL Server Management Studio, run the following query and match the output to the errors listed in the table below: <br> <br> <font color="greY">select * from [virtualDBA].[dbo].[vw_adm_setup_log];</font> <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>error</th> <th>resolution</th> </tr> <tr> <td width="25%">SQL Agent service must be running</td> <td>The virtualDBA system installs a number of SQL Agent jobs during the setup/installation. Start the SQL Agent service and re-run the setup procedure.</td> </tr> <tr> <td>specified '@server' is invalid</td> <td>The name of your SQL instance does not match with its network name. Run a comparison between @@servername and ServerProperty('ServerName') - if the two values are not the same, match your @@servername name by using sp_dropserver/sp_addserver (see Books Online for more details.) Caution - changing the SQL name of your server could result in issues with your database/applications. Please consult your development team(s) before making any changes.</td> </tr> <tr> <td>SET options have incorrect settings</td> <td>Before running the setup procedure, make sure that the session settings QUOTED_IDENTIFIER and ANSI_PADDING are set to 'ON'.</td> </tr> <tr> <td>Other</td> <td>Please contact eleven27 support (support@virtualdba.ca) for assistance.</td> </tr> </table> <p>&nbsp</p> <hr> <br> <a name="configuration"><font size="3" color="silver"><strong>the.</strong></font><font size="3" color="#0066cc"><strong>configuration</strong></font></a> <br> <br> <br> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I get the virtualDBA alerting features working?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> To enable the virtualDBA alerting features, you must first setup an SQL Server database mail profile (see Books Online for more details or contact eleven27 support.) Once the profile has been setup, you can enable the system alerts using the following: <br> <br> <font color="grey">update [virtualDBA].[dbo].[vw_config_system_alerts] <br> set enabled = 1, <br> alert_by_eventlog_enabled = 0, <br> alert_by_mail_enabled = 1, <br> mail_profile = '&lt;your_dbmail profile&gt;', <br> mail_recipient_email_address = '&lt;dba@yourcompany.com&gt;', <br> html_enabled = 1;</font> <br> <br> In order to enable the virtualDBA reporting feature: <br> <br> <font color="grey">update [virtualDBA].[dbo].[vw_config_reporting] <br> set enabled = 1, <br> mail_profile = '&lt;your_dbmail profile&gt;';</font> <br> <br> <font color="grey">update [virtualDBA].[dbo].[vw_config_reporting_templates] <br> set agent_enabled = 1, <br> email = '&lt;dba@yourcompany.com&gt;';</font> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have installed virtualDBA but I need to disable some of the maintenance features on a few databases. How do I do this?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can enable/disable and configure all maintenance specific tasks (consistency checks, index rebuilds, backups, etc.) through the following view: <br> <br> <font color="grey">[virtualDBA].[dbo].[vw_config_maintenance_db]</font> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I accidently updated a number of maintenance/monitor settings for all of my databases instead of just the one I wanted. Is there a way to get my previous settings back?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Definitely. When you make changes to the maintenance and monitoring configuration views, a snapshot of the pre-changed rows is saved in a number of history views: <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>view</th> <th>description</th> </tr> <tr> <td width="25%">dbo.vw_history_config_maintenance_db</td> <td>View historical snapshot data for any database maintenance configuration changes.</td> </tr> <tr> <td>dbo.vw_history_config_maintenance_log</td> <td>View historical snapshot data for any transaction log maintenance configuration changes.</td> </tr> <tr> <td>dbo.vw_config_history_monitor_db</td> <td>View historical snapshot data for any database monitoring configuration changes.</td> </tr> <tr> <td>dbo.vw_config_history_monitor_dbm</td> <td>View historical snapshot data for any database mirroring monitor configuration changes.</td> </tr> </table> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have installed virtualDBA and configured the proper maintenance settings for my databases. I plan to add a number of databases in the future but I want them to use a different backup path when virtualDBA detects and configures them. Is this possible?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can pre-configure the default maintenance and monitoring settings using the following views: <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>view</th> <th>description</th> </tr> <tr> <td width="25%">dbo.vw_config_default_maintenance_db</td> <td>Set the default database maintenance settings for all new databases.</td> </tr> <tr> <td>dbo.vw_config_default_maintenance_log</td> <td>Set the default transaction log maintenance settings for all new databases.</td> </tr> <tr> <td>dbo.vw_config_default_monitor_db</td> <td>Set the default database monitoring settings for all new databases.</td> </tr> </table> <br> <br> These views allow you to set the defaults for any new database that virtualDBA detects - it does not change the settings for your existing databases. <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have a custom stored procedure or third-party application (ie LiteSpeed) that I use to backup one or more of my databases. Can I still use this? Can I have virtualDBA notify me if it fails?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Absolutely. You can setup a maintenance override task and enable it in place of the virtualDBA backup process. The override can be setup in the dbo.vw_config_maintenance_overrides view as follows: <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr> <td width="25%">override_id</td> <td>The unique ID of the override record. </td> </tr> <tr> <td>alert_enabled</td> <td>Send an alert if the override fails. This is dependent on the error code returned by the override TSQL statement(s).</td> </tr> <tr> <td>tsql</td> <td>The TSQL code. This can be any valid TSQL statement including stored procedure execution, DML, third-party extended stored procedures, etc.</td> </tr> <tr> <td>description</td> <td>A summary of the override record. This is used for descriptive purposes only.</td> </tr> </table> <br> Once the override has been setup, simply add the ID to the maintenance configuration for the database(s) you wish to override: <br> <br> <font color="grey">update [virtualDBA].[dbo].[vw_config_maintenance_db] set bu_db_override_id = &lt;override_id&gt; where database_name = '&lt;database_name&gt;';</font> <br> <br> The next time the maintenance process runs the backup task, it will automatically run the override syntax. All core maintenance tasks have the option to include an override on both a daily or weekly basis. If you wish to disable an override, simply set the ID to 0 in the maintenance configuration: <br> <br> <font color="grey">update [virtualDBA].[dbo].[vw_config_maintenance_db] set bu_db_override_id = 0 where database_name = '&lt;database_name&gt;';</font> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I use a third-party command line tool to compress my backups?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Third-party command line tools can be integrated into the virtualDBA backup routines by updating the maintenance configuration views to include the 'core' compression syntax - virtualDBA will handle the file naming convention. For example, if you wanted to include compression using 7-Zip: <br> <br> <font color="greY"> update [virtualDBA].[dbo].[vw_config_maintenance_db] set <br> bu_db_external_compression_enabled=1, <br> bu_db_external_compression_command='"c:\program files\7-zip\7z.exe" a -t7z -m0=lzma -mx=1 -mfb=64 -md=64m', <br> bu_db_external_compression_extension='7z', <br> where database_name = '&lt;database_name&gt;';</font> <br> <br> Any command line based compression utility is supported however you may need to test variations of the 'core' settings to get it to work. If you have any problems with a specific compression utility, contact eleven27 support for assistance. <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I enable the backup-and-copy feature?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can enable this feature by executing the following command for each database that you want copied: <br> <br> <font color="greY"> update [virtualDBA].[dbo].[vw_config_maintenance_db] set <br> bu_db_file_copy_enabled = 1, <br> bu_db_file_copy_unc_path = '&lt;unc_path&gt;' <br> where database_name = '&lt;database_name&gt;';</font> <p>If you have enabled third-party backup compression, you can copy the compressed file instead of the original backup file:</p> <font color="greY"> update [virtualDBA].[dbo].[vw_config_maintenance_db] set <br> bu_db_file_copy_compressed_file_enabled = 1 <br> where database_name = '&lt;database_name&gt;';</font> <br> <br> <strong>Note: The SQL Server Agent service account must have access to the &lt;unc_path&gt; path.</strong> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Why is the native SQL 2008 compression unavailable in virtualDBA?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Support for native SQL 2008 compression will be available in the next major release of virtualDBA (v4.0.0) <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have installed virtualDBA but all of the database maintenance jobs are scheduled/running at the same time? Can I change the schedule for a few databases?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Absolutely. virtualDBA uses a default schedule for all databases but you can reschedule this for any database agent according to your environment. The next major release of virtualDBA (v4.x) includes a "smart scheduling" technology that will "offset" each job agent based on the resources and duration required to maintain each database. <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I configure the database monitoring features?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can configure the database monitoring features using the dbo.vw_config_monitor_db view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr><td width="25%">database_name</td><td>The database name.</td></tr> <tr><td>fxs_enabled</td><td>Enable/disable the file expansion/shrink monitor. This requires the SQL Server default trace to be running (see BOL or contact support@virtualdba.ca for asistance.)</td></tr> <tr><td>fxs_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>ios_enabled</td><td>Enable/disable the database file IO stall monitor.</td></tr> <tr><td>ios_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>ndx_miss_enabled</td><td>Enable/disable the missing index monitor.</td></tr> <tr><td>ndx_miss_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>ndx_ops_enabled</td><td>Enable/disable the index operational statistics monitor.</td></tr> <tr><td>ndx_ops_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>ndx_usg_enabled</td><td>Enable/disable the index usage monitor.</td></tr> <tr><td>ndx_usg_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>qry_blk_enabled</td><td>Enable/disable the blocked query monitor.</td></tr> <tr><td>qry_blk_min_wait_sec</td><td>The minimum amount of time (in seconds) a query sits in a blocked state before the monitor detects it.</td></tr> <tr><td>qry_blk_alert_enabled</td><td>Enable/disable an email alert when a blocked query is detected.</td></tr> <tr><td>qry_blk_alert_email_cc</td><td>An email CC address for blocked query alerts. Multiple addresses should be semi-colon separated.</td></tr> <tr><td>qry_blk_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>qry_run_enabled</td><td>Enable/disable the long running query monitor.</td></tr> <tr><td>qry_run_min_exec_sec</td><td>The minimum amount of time (in seconds) a query is running before the monitor detects it.</td></tr> <tr><td>qry_run_alert_enabled</td><td>Enable/disable an email alert when a long running is detected.</td></tr> <tr><td>qry_run_alert_email_cc</td><td>An email CC address for long running query alerts. Multiple addresses should be semi-colon separated.</td></tr> <tr><td>qry_run_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>qry_sts_enabled</td><td>Enable/disable the query statistics monitor. This monitor will track query CPU/IO/Plan re-use/duration/etc. statistics.</td></tr> <tr><td>qry_sts_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>usg_db_enabled</td><td>Enable/disable the database usage monitor.</td></tr> <tr><td>usg_db_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>usg_obj_enabled</td><td>Enable/disable the database per-object/per-index usage monitor.</td></tr> <tr><td>usg_obj_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> <tr><td>ft_crawl_enabled</td><td>Enable/disable the FullText crawl monitor.</td></tr> <tr><td>ft_crawl_duration_sec</td><td>The minimum amount of time (in seconds) a crawl is running before the monitor detects it.</td></tr> <tr><td>ft_crawl_alert_enabled</td><td>Enable/disable an email alert when a long running crawl is detected.</td></tr> <tr><td>ft_crawl_log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> </table> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Is there a way to monitor the overall disk space usage on my systems?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Definitely. You can enable a disk subsystem monitor using the [dbo].[vw_config_monitor_srv_disks] view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr><td width="25%">enabled</td><td>Enable/disable the disk monitor.</td></tr> <tr><td>alert_enabled</td><td>Enable/disable an email alert when the estimated days remaining threshold has been met.</td></tr> <tr><td>alert_estimated_days_remaining</td><td>The minimum amount of days remaining before the disk space runs out and the monitor detects it. Note: this is an estimated value and may appear negative if a large number of files are deleted from the disk.</td></tr> <tr><td>log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> </table> <br> <br> If you want manually track the disk space changes on a daily basis, you can do so via: <br> <br> <font color="greY"> select * from [virtualDBA].[dbo].[vw_monitor_srv_disks];</font> <br> <br> This will provide you with a daily breakdown of disk usage metrics. <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I monitor TempDB usage?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can enable the TempDB usage monitor by using the [dbo].[vw_config_monitor_srv_tempDB] view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr><td width="25%">enabled</td><td>Enable/disable the TempDB usage monitor.</td></tr> <tr><td>min_per_session_page_count</td><td>The minimum amount of pages (8K) a connected session must consume before the monitor detects it.</td></tr> <tr><td>alert_enabled</td><td>Enable/disable an email alert when the pages threshold has been met.</td></tr> <tr><td>log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr></table> <br> <br> You can manually view the TempDB monitor usage via: <br> <br> <font color="greY"> select * from [virtualDBA].[dbo].[vw_monitor_srv_TempDB];</font> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Is there a way to monitor the SQL Server logs?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Absolutely. You can monitor the SQL logs and send alerts when specific log entries are detected. The log monitor is configurable using the [dbo].[vw_config_monitor_srv_logs] view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr><td width="25%">enabled</td><td>Enable/disable the SQL log monitor.</td></tr> <tr><td>backlog_hrs</td><td>The maximum amount of time (in hours) that the monitor will use when detecting log entries based on the log date.</td></tr> <tr><td>log_retention_hrs</td><td>The amount of log history (in hours) to retain for this monitor.</td></tr> </table> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have enabled the SQL Server log monitor but I want to be alerted when certain log entries occur. How do I do this?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can enable/disable email alerts for the SQL log monitor using the [dbo].[vw_config_monitor_srv_logs_alerts] view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr><td width="25%">enabled</td><td>Enable/disable the SQL log monitor alerts.</td></tr> <tr><td>log_keyphrase</td><td>An SQL Log keyphrase that is picked up by the monitor. For example 'Backup Failed'.</td></tr> <tr><td>email_subject_tag</td><td>A tag that will be appended to the start of the email subject field (ie Server Restarted - ). This is very useful if you have email filters in place for a specific email address and only want to see certain messages.</td></tr> </table> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have enabled the SQL Server log monitor and alerting features but I need to filter out some of the alerts I am receiving. Is this possible?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Definitely. You may have added ERROR as an alert keyphrase but you don't want to receive an alert when the error log has been reintialized. You can setup a filter for this using the [dbo].[vw_config_monitor_srv_logs_filter] view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr><td width="25%">enabled</td><td>Enable/disable the SQL log scanner filter.</td></tr> <tr><td>log_keyphrase</td><td>A keyphrase used to filter the log entries.</td></tr> </table> <br> <br> For example, to filter out the SQL log reinitialization mentioned above, simply add the filter keyphrase: -e%errorlog <br> The filter keyphrase supports wildcard (%) characters! <br> <p>&nbsp</p> <hr> <br> <a name="maintenance"><font size="3" color="silver"><strong>the.</strong></font><font size="3" color="#0066cc"><strong>maintenance</strong></font></a> <br> <br> <br> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>If virtualDBA is maintaining all my database backups, how will I know which files to restore in the event that I need to recover a database?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> virtualDBA dynamically builds recovery scripts as each database or log is backed up. You can access the recovery script for a particular database by executing the following: <br> <br> <font color="greY">select restore_script from [virtualDBA].[dbo].[vw_maintenance_current_backups] where database_name = &lt;database_name&gt; order by backup_start_date; </font> <br> <br> restore database [mydb] from disk = 'd:\sqlbkup\11NOV2010T022426D_mydb_full_bkup.bak' with file = 1, replace, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T022426L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T023000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T030000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T033001L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T040000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T043001L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T050001L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T053001L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T060000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T063000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T070000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T073000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T080000L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T083001L_mydb_log_bkup.bak' with file = 1, norecovery; <br> restore log [mydb] from disk = 'd:\sqlbkup\11NOV2010T090001L_mydb_log_bkup.bak' with file = 1, recovery; <br> <p>&nbsp</p> <hr> <br> <a name="audit"><font size="3" color="silver"><strong>the.</strong></font><font size="3" color="#0066cc"><strong>audit</strong></font></a> <br> <br> <br> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I enable DDL Audting?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> To enable DLL auditing, execute the following command: <br> <br> <font color="greY"> update [virtualDBA].[dbo].[vw_config_audit] set <br> enabled = 1, <br> where audit_type = 'ddl';</font> <br> <br> The DLL audit will be enabled once the next scheduled DDL Audit Agent runs. <br> <br> There are 4 separate audit types that can be enabled - DDL, Security, Locks and Mirroring. <br> <br> To check the status of an audit type or to see if any events have not been logged: <br> <br> <font color="greY">select * from [virtualDBA].[dbo].[vw_queue_audit];</font> <br> <br> To view auditied events: <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>view</th> <th>description</th> </tr> <tr> <td width="25%">dbo.vw_audit_ddl</td> <td>View all DDL audit events.</td> </tr> <tr> <td>dbo.vw_audit_locks</td> <td>View all deadlock occurence events.</td> </tr> <tr> <td>dbo.vw_audit_mirroring</td> <td>View all Database Mirroring state change events.</td> </tr> <tr> <td>dbo.vw_audit_security</td> <td>View all security related events.</td> </tr> </table> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Is there a way to receive an email alert when a DDL audit event occurs?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Absolutely. By default, the audit events are pre-configured with alerting set to disabled. You can change this default setup by updating or adding records to the dbo.vw_config_audit_alerts_ddl view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr> <td width="25%">alert_enabled</td> <td>Enable the alerts for this event.</td> </tr> <tr> <td width="25%">alert_event</td> <td>The audit event name. This must be a valid DDL Event Notification.</td> </tr> <tr> <td width="25%">alert_database_name</td> <td>The name of the database for this event. A value of NULL represents all databases.</td> </tr> <tr> <td width="25%">alert_email_cc</td> <td>By default, all alerts will be sent to the account setup in the dbo.vw_config_systems_alerts view. If you wish to cc an email address on a specific event, you can do so by adding the account(s) to this column. Multiple accounts can be added using a semi-colon separator.</td> </tr> </table> <br> <br> If you want to enable alerts for all events/databases, simply run the following: <br> <br> <font color="greY"> update [virtualDBA].[dbo].[vw_config_audit_alerts_ddl] set <br> enabled = 1;</font> <br> <br> If you want to enable all alerts for a specific database, you can add the new records as follows: <br> <br> <font color="greY"> insert [virtualDBA].[dbo].[vw_config_audit_alerts_ddl] select 1, alert_event, &lt;database_name&gt;, null from [virtualDBA].[dbo].[vw_config_audit_alerts_ddl] where alert_database_name is null;</font> <br> <br> <p>&nbsp</p> <hr> <br> <a name="reporting"><font size="3" color="silver"><strong>the.</strong></font><font size="3" color="#0066cc"><strong>reporting</strong></font></a> <br> <br> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>I have enabled the reporting features but I don't receive any of the default reports. How do I enable these?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can enable the default reports by executing the following command: <br> <br> <font color="greY">update [virtualDBA].[dbo].[vw_config_reporting_templates] set agent_enabled = 1;</font> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>How do I create a custom report?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> You can create a custom report (or modify an existing one) using the dbo.vw_config_reporting_templates view. <br> <br> <table border="1" width="98%" bgcolor="#EEEEFF" cellpadding="5" align="center"> <tr> <th>column</th> <th>description</th> </tr> <tr> <td width="25%">agent_enabled</td> <td>Enables the generation of a report through the scheduled reporting agent. If you wish to schedule a report outside of the reporting agent, you can set this column to 0 and setup a custom job.</td> </tr> <tr> <td>report_id</td> <td>A unique ID for the report.</td> </tr> <tr> <td>title</td> <td>The report title.</td> </tr> <tr> <td>description</td> <td>A summary description of the report.</td> </tr> <tr> <td>tsql</td> <td>The TSQL statement. This can be any valid TSQL code and can span any database or linked server configuration that the SQl Server Agent service account has access to. There is no support for stored procedures in version v3.x.x.</td> </tr> <tr> <td>email</td> <td>A semi-colon separated list of email accounts to send the report to.</td> </tr> <tr> <td>include_xml</td> <td>Include a secondary email containing an XML based attachemnt of the report results.</td> </tr> <tr> <td>include_xml_only</td> <td>Send a single report containing an XML based attachemnt of the report results only (no HTML.)</td> </tr> <tr> <td>log_retention_hrs</td> <td>The length of time (hours) to maintain reporting history.</td> </tr> <tr> <td>alert_threshold_enabled</td> <td>Enable an email alert if the time taken to generate the report exceeds a threshold value.</td> </tr> <tr> <td>alert_threshold_report_duration_sec</td> <td>An alert threshold value representing the length of time (seconds) taken to generate a report.</td> </tr> <tr> <td>html_font_face</td> <td>The HTML font face.</td> </tr> <tr> <td>html_title_cell_background_colour</td> <td>The HTML title background colour.</td> </tr> <tr> <td>html_title_cell_font_colour</td> <td>The HTML title font colour.</td> </tr> <tr> <td>html_data_cell_background_colour</td> <td>The HTML data background colour.</td> </tr> <tr> <td>html_data_cell_font_colour</td> <td>The HTML data font colour.</td> </tr> <tr> <td>html_table_border_width</td> <td>The HTML table border width.</td> </tr> <tr> <td>html_table_border_width</td> <td>The HTML table border width.</td> </tr><tr> <td>html_cell_padding</td> <td>The HTML table cell padding.</td> </tr><tr> <td>html_logo_url</td> <td>An HTML logo file/image. Can be a UNC path or a URL.</td> </tr> </table> <br> <br> If you want to schedule a report outside of the reporting agent, you can setup a job step using the following code: <br> <br> <font color="greY">exec [virtualDBA].[dbo].[up_rep] &lt;report_id&gt;;</font> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Does virtualDBA keep a log of the reports?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Yes. virtualDBA has a central logging view that tracks the outcome of all reports. <br> <br> <font color="greY">select * from [virtualDBA].[dbo].[vw_reporting_log];</font> <br> <br> <p>&nbsp</p> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Aside from the default reporting templates that come with virtualDBA, do you have any other templates that I can use to monitor my system?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Absolutely. We have provided a number of sample reports below and will continue to add this list. You will need to modify the &lt;report_id&gt; and email address for each template to suit your environment. <br> <br>Visit us often to check out the latest templates or follow us on Twitter to receive updates. Also, if you have come up with some creative templates and want to share them with other virtualDBA users, please feel free to get in touch in with us and we can add them to the list! <br> <br> [Template: Index Usage] <br> List index usage information for indexes that have high scan-to-seek to user-to-maintenance ratios. <br> <br> <font color="grey">insert [virtualDBA].[dbo].[vw_config_reporting_templates] <br>( <br>agent_enabled, <br>report_id, <br>title, <br>description, <br>tsql, <br>email, <br>log_retention_hrs, <br>alert_enabled, <br>alert_threshold_report_duration_sec <br>) <br>values <br>( <br>1, <br>&lt;report_id&gt;, <br>'Database Profile - Index usage statistics', <br>'Database Profile - Index usage statistics where scans vs seeks > 75% or maintenance vs user > 75%.', <br>'select log_date, database_name, object_name, index_name, user_seeks, user_scans, user_lookups, last_user_update, maintenance_updates maintenance_updates, 100*cast((case when user_seeks = 0 then 1 else user_scans*1.0/(user_seeks+user_scans) end) as decimal(10,3)) percent_scans_vs_seeks, pct_maintenance_vs_user percent_maintenance_vs_user from [virtualDBA].[dbo].[vw_monitor_db_index_stats_usage] where (log_date between cast(convert(varchar(30), getdate(), 12) as datetime)-1 and cast(convert(varchar(30), getdate(), 12) as datetime)) and user_seeks is not null and (pct_maintenance_vs_user > 75 or (100*cast((case when user_seeks = 0 then 1 else user_scans*1.0/(user_seeks+user_scans) end) as decimal(10,3)))>75) order by pct_maintenance_vs_user desc;', <br>'support@mycompany.com', <br>168, <br>0, <br>5</font> <br>); <br> <br> <br> [Template: Buffer Pool] <br> Provides average buffer pool usage (in MB) on a per database basis. This template assumes that you have enabled the database memory monitors. <br> <br> <font color="grey">insert [virtualDBA].[dbo].[vw_config_reporting_templates] <br>( <br>agent_enabled, <br>report_id, <br>title, <br>description, <br>tsql, <br>email, <br>log_retention_hrs, <br>alert_enabled, <br>alert_threshold_report_duration_sec <br>) <br>values <br>( <br>1, <br>&lt;report_id&gt;, <br>'Database Profile - Buffer Pool Memory Usage', <br>'Database Profile - Buffer Pool Memory Usage', <br>'select database_name, avg(buffer_pool_size_current_mb) avg_sample_buffer_pool_size_mb from [virtualDBA].[dbo].vw_monitor_db_memory (nolock) group by database_name;', <br>'support@mycompany.com', <br>168, <br>0, <br>5</font> <br>); <br> <br> <p>&nbsp</p> <hr> <br> <a name="system"><font size="3" color="silver"><strong>the.</strong></font><font size="3" color="#0066cc"><strong>system</strong></font></a> <br> <br> <br> <strong>Q<font color="#0066cc">uestion:</font></strong> <br> <strong>Does virtualDBA have it's own logs?</strong> <br> <br> <strong>A<font color="#0066cc">nswer:</font></strong> <br> Yes. virtualDBA has a central logging view that tracks all errors, events, notifications, etc. <br> <br> <font color="greY">select * from [virtualDBA].[dbo].[vw_system_log];</font> <br> <br> <p>&nbsp</p> <br> <strong>This section is being moved to our online Forums! Please feel free to register and contribute your feedback to the virtualDBA project.</strong> <br> </font> </td></tr></table> </td> <td class="shadow-right"></td> </tr> <tr> <td class="shadow-bottomLeft"></td> <td class="shadow-bottom"></td> <td class="shadow-bottomRight"></td> </tr> </table> </td> <!--Right--> <td valign="top" width="12%"> <table width="100%" class="shadow-sd" border="0" cellspacing="0" cellpadding="0" valign="top"> <tr> <td class="shadow-sd-topLeft"></td> <td class="shadow-sd-top"></td> <td class="shadow-sd-topRight"></td> </tr> <tr> <td class="shadow-sd-left"></td> <td class="shadow-sd-center" valign="top"> <center><a href="http://www.virtualdba.ca/main/downloads/vdba.zip" class="fbTooltip" data-fb-tooltip="source:#ttip_dwnld attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/dwnapp.png" border="0"></a></center> <center><a href="http://www.virtualdba.ca/main/downloads/vdba.zip" class="fbTooltip" data-fb-tooltip="source:#ttip_dwnld attachToHost:true" alt=""><font size="2" color="silver"><strong>download.<strong></font><font size="2" color="#000000"><strong>virtualDBA</strong></font></a></center> <br> <center><a href="http://www.virtualdba.ca/main/downloads/vdbadoc.zip" class="fbTooltip" data-fb-tooltip="source:#ttip_dwnld attachToHost:true" alt=""><img src="http://static.virtualdba.ca/img/png/dwndoc.png" border="0"></a></center> <center><a href="http://www.virtualdba.ca/main/downloads/vdbadoc.zip" class="fbTooltip" data-fb-tooltip="source:#ttip_dwnld attachToHost:true" alt=""><font size="2" color="silver"><strong>download.<strong></font><font size="2" color="#000000"><strong>documentation</strong></font></a></center> <br><br> <center><img src="http://static.virtualdba.ca/img/png/dwnldinfo.png" border="0"></center> <br> <td class="shadow-sd-right"></td> </tr> <tr> <td class="shadow-sd-bottomLeft"></td> <td class="shadow-sd-bottom"></td> <td class="shadow-sd-bottomRight"></td> </tr> <tr> <td class="shadow-sd-topLeft"></td> <td class="shadow-sd-top"></td> <td class="shadow-sd-topRight"></td> </tr> <tr> <td class="shadow-sd-left"></td> <td class="shadow-sd-center" valign="top"> <center><a href="http://www.twitter.com/virtualDBA"><img src="http://static.virtualdba.ca/img/png/twitter.png" border="0"></a></center> <center><a href="http://www.twitter.com/virtualDBA"><font size="2" color="silver"><strong>get.updates.<strong></font><font size="2" color="#000000"><strong>Twitter</strong></font></a></center> <br> <center><a href="http://www.facebook.com/sharer.php?u=http%3A%2F%2Fvirtualdba.ca%2Fmain%2F&t=virtualDBA&src=sp"><img src="http://static.virtualdba.ca/img/png/facebook.png" border="0"></a></center> <center><a href="http://www.facebook.com/sharer.php?u=http%3A%2F%2Fvirtualdba.ca%2Fmain%2F&t=virtualDBA&src=sp"><font size="2" color="silver"><strong>share.this.</strong></font><font size="2" color="#000000"><strong>Facebook®</strong></font></a></center> <br> <center><a href="http://digg.com/submit?url=http://www.virtualdba.ca/main&title=virtualDBA&bodytext=Free Automated Database Maintenance, Monitoring and Auditing&media=news&topic=tech_news"><img src="http://static.virtualdba.ca/img/png/digg.png" border="0"></a></center> <center><a href="http://digg.com/submit?url=http://www.virtualdba.ca/main&title=virtualDBA&bodytext=Free Automated Database Maintenance, Monitoring and Auditing&media=news&topic=tech_news"><font size="2" color="silver"><strong>share.this.</strong></font><font size="2" color="#000000"><strong>Digg</strong></font></a></center> <br> <center><a href="http://del.icio.us/post?url=http://www.virtualdba.ca/main/&title=virtualDBA"><img src="http://static.virtualdba.ca/img/png/delicious.png" border="0"></a></center> <center><a href="http://del.icio.us/post?url=http://www.virtualdba.ca/main/&title=virtualDBA"><font size="2" color="silver"><strong>share.this.</strong></font><font size="2" color="#000000"><strong>Delicious</strong></font></a></center> <br> <center><a href="mailto:?Subject=virtualDBA - Fully Automated Database Maintenance, Monitoring and Auditing. It's Free!&body=www.virtualdba.ca"><img src="http://static.virtualdba.ca/img/png/email.png" border="0"></a></center> <center><a href="mailto:?Subject=virtualDBA - Fully Automated Database Maintenance, Monitoring and Auditing. It's Free!&body=www.virtualdba.ca"><font size="2" color="silver"><strong>share.this.</strong></font><font size="2" color="#000000"><strong>email</strong></font></a></center> <br> </td> <td class="shadow-sd-right"></td> </tr> <tr> <td class="shadow-sd-bottomLeft"></td> <td class="shadow-sd-bottom"></td> <td class="shadow-sd-bottomRight"></td> </tr> <tr> <td class="shadow-sd-topLeft"></td> <td class="shadow-sd-top"></td> <td class="shadow-sd-topRight"></td> </tr> <tr> <td class="shadow-sd-left"></td> <td class="shadow-sd-center" valign="top"> <br> <center> <script type="text/javascript"><!-- google_ad_client = "pub-2594325326822095"; google_ad_slot = "3052378601"; google_ad_width = 120; google_ad_height = 600; //--> </script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script> </center> </td> <td class="shadow-sd-right"></td> </tr> <tr> <td class="shadow-sd-bottomLeft"></td> <td class="shadow-sd-bottom"></td> <td class="shadow-sd-bottomRight"></td> </tr> </table> </td> </tr> </table> <!--Tips--> <div id="ttip_prod" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">virtualDBA - A fully automated database maintenance, monitoring and auditing system for SQL Server 2005/2008.</font> </div> </div> <div id="ttip_supp" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">Have a question or concern? Get in touch with us!</font> </div> </div> <div id="ttip_faq" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">Check out our FAQ section to get the latest information regarding installation, configuration and support information.</font> </div> </div> <div id="ttip_blog" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">Check out our blog to see the latest and greatest news and comments about virtualDBA.</font> </div> </div> <div id="ttip_comm" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">Visit our virtualDBA Forums to share information and get assistance.</font> </div> </div> <div id="ttip_about" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">Want to know more about the company that created virtualBDA?</font> </div> </div> <div id="ttip_dwnld" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">Access downloads using the following credentials:<br>[UserName:] virtualDBA<br>[Password:] download</font> </div> </div> <div id="ttip_vault" style="display:none; width:300px;"> <div style="float:left;"> <img src="http://static.virtualdba.ca/img/png/vdba_logo3.png" width="30" height="30" alt="" style="margin:4px 0 0 4px; border-width:0;"/> </div> <div style="float:right; font-size:12px; margin:8px 0; width:250px;"> <font face="Arial" size="2" color="#000000">A complete library of free SQL Scripts. Have a script that could help someone else? Add it!</font> </div> </div> </body> </html>