If you look at your car like you look at your database, you might not be going anywhere for the holidays…. Your data, is ever changing, and growing and evolving, but who monitors it as it grows from a small bug to a beautiful butterfly? Know Informatics, the Development and DBA part of LOEC is introducing a DB server monitoring service.
What does it entail?
Each morning we will send a mail, like the one below to you (if you want) and ourselves. It should tell us that everything is still purring along like a kitten, or if something has changed, or is not working. In our experiences, things can lie unnoticed for a prolonged amount of time, and then have a massive impact on business.
We will generate a task daily, making sure we expect your mail allowing us to question why we didn’t get it, and if we got it why something is off, or failing, and address it with you before it becomes an issue for your business. In addition, it will show us how fragmented your databases are, making it easy to spot when we need to do a little maintenance (you have been driving this SQL car without an odo till now…) and tell us how your full, or empty your drives are making sure SQL has the space it needs to do its job, as well as showing when the last SDQL backup was made, and where to, so that we all can rest assured that in the event of an emergency we have something recent to fall back on.
Your SQL server
Server Information
|
Server name |
Version |
Edition |
Service Pack |
Collation |
License Type |
Single User |
Clustered |
|
Demo |
Microsoft SQL Server 2012 |
Express Edition (64-bit) |
RTM |
SQL_Latin1_General_CP1_CI_AS |
DISABLED |
No |
No |
SQL Services
|
Service |
Startup Type |
Status |
|
SQL Server (MSSQLSERVER) |
Automatic |
Running |
|
SQL Server Agent (MSSQLSERVER) |
Disabled |
Stopped |
Database Information
|
Database Name |
Fragmentation index |
Created |
Total Size MB |
MDF Space Information |
LDF Space Information |
DB State |
Recovery Model |
Backup Type |
Last Backup Location |
Started Time |
Completed |
Size(MB)
|
|
Database 1 |
55.00 |
7-Aug-2014 |
8.00 |
7.00, 1.75 free |
1.50, 0.60 free |
ONLINE |
SIMPLE |
Full |
C:\Users\Administrator\Dropbox\KI_WS\backup\db1.bak |
2016-12-01 06:00:01 |
2016-12-01 06:00:01 |
5.58 |
|
Database 2 |
1.72 |
14-Nov-2016 |
8.00 |
6.00, 1.50 free |
2.00, 1.30 free |
ONLINE |
SIMPLE |
Full |
C:\Users\Administrator\Dropbox\KI_WS\backup\db2.bak |
2016-12-01 06:00:01 |
2016-12-01 06:00:01 |
5.84 |
Job Information
|
Job Name |
Enabled |
Last Run |
Category |
Last Run Date |
Execution Time |
|
syspolicy_purge_history |
True |
Unknown |
[Uncategorized (Local)] |
0 |
0 |
Disk Statistics
Good as long as free space size is greater than 10%
|
Disk |
Total Space (MB) |
Free Space (MB) |
Percentage Free(%) |
DB Alert
|
|
C |
99.90 |
80.74 |
80.82 |
fine |
SQL Mails
|
Status |
Count |
|
failed |
0 |
|
retrying |
0 |
|
sent |
11 |
|
unsent |
0 |
You can probably download free tools to monitor your server for you, but we have seen that if you do not task an individual that knows what he is looking at (we have been looking at SQL servers since 2002) ,to look at it every day, monitoring just becomes another mail in your inbox.
If you are interested, we will be billing you only R500.00 Excl per month for this service for one SQL instance, R 350 for 2 or R 300 for 3 or more.
For any enquirers or questions feel free to pop Jannie (jg@knw.za.net) or Endy (endy.ukhurebor@loec.co.za) a mail, or chat to us on Skype like many of you do already.
