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.

Industry SA just had to do an article about one of the most dynamic, and fast moving companies in South Africa, so they wrote one about Netflorist….

The question would be, why would it affect us? Obviously, as technologically inclined people we often use Netflorist’s fast and effective service for ourselves, but we have also been involved with Netflorist’s systems over many many years. We assisted them in setting up and running Sage Evolution in the days when modems still dialed in, and helped them integrate the Web Front end with their accounting system as well as doing all the planning for major events in FullCircle. So we got some space on the same pages…

syn·er·gy

the interaction or cooperation of two or more organizations, substances, or other agents to produce a combined effect greater than the sum of their separate effects.

League of Extraordinary Consultants is what happens when 3 separate entities fuse into one vision , each focusing on its strengths, enabling us to give our clients the most effective solutions in the most efficient ways. Synergy is what happened, or in the immortal words of A-Team Captain John “Hannibal” Smith : “I love it when a plan comes together” .

Why are we bold enough to make the word extraordinary part of our identity?

It sounds pretty cool… but,

1. We have been in the business of giving companies business solutions for the last 15 years.