Archive for Uncategorized

You check your car’s oil level, and take it for a service, but who looks after your database?

 

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.