Review
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

Review of Spotlight on SQL Server by Pinal Dave – FREE SQL PowerPoint PPT Presentation


This review is based on the FREE SQL Server performance monitoring tool: Spotlight on SQL Server. The installation was straight forward and easy. When I inquired about the price, I was happy, in fact I was very happy as it was totally FREE! I recently I got some time and I downloaded the Spotlight on SQL Server Freemium FREE tool. It took less than 10 seconds to install the tool. Once I installed the plug-in, it was very easy to use it as it becomes an integral part of the SQL Server Management Studio. The interface is very user friendly. Meanwhile, I strongly suggest you download Spotlight on SQL Server Freemium and make sure your servers are healthy. Click here to download the SQL tool : http://bit.ly/16CSDmt

Download Presentation

Review of Spotlight on SQL Server by Pinal Dave – FREE SQ...

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Review of spotlight on sql server by pinal dave free sql

ReviewofSpotlighton

SQL

Server

FREE

SQL

ServerTools

PinalDave

SQLServer Professional

ProfuseSQLWriter

SQLServerDBAProfessionals

Global Marketing


Review of spotlight on sql server by pinal dave free sql

Thisreviewisbased

onthe

FREESQLServer

performancemonitoring

tool:

Spotlight

on

SQL

Server.

SQLDBApros

2


Review of spotlight on sql server by pinal dave free sql

lifegoal….

A

DBA’s

IfyouthinkofaDBA'slife,ithas

oneverysimplegoal -their server shouldnevergodownand allthe queries shouldalways perform excellently.

However,justlikeanyotherlife goals, itisnot possibletoachieve that easily.

Ioftensee DBA'scontinuously

watchingtheir monitortomake sure

that their serversarerunningfine.Anotherhabit ofmostDBAsisto

continuouslychecktheir mobilephoneforalerts.

Nowadaysweget somanyalerts itsgettinghardertokeepwatchon the mostimportantones.Manycontinuetosearchathometocatch suspiciousalerts.

SQLDBApros

3


Review of spotlight on sql server by pinal dave free sql

SQLPASS2013

Earlierthisyear,whenIattended

SQLPASS2013,I stoppedbythe Dellboothtosee whatthey have new inthe SQLServerworld.

InoticedSpotlightonSQLServer Freemiumrunningontheir monitor.

When Iinquiredaboutthe price, I

asitwastotallyFREE!

washappy,infactIwasveryhappy

IrecentlyIgot sometime and IdownloadedtheSpotlightonSQL

ServerFreemiumFREEtool.

SQLDBApros

4


Review of spotlight on sql server by pinal dave free sql

Installation

Theinstallationwasstraight

forwardand easy.

Ittooklessthan10secondsto

installthe tool.

OnceIinstalledthe plug-in,it

wasveryeasytouse itasit

becomesanintegralpartofthe

SQLServerManagementStudio.

Theinterfaceisveryuser

friendly.

SQLDBApros

5


Review of spotlight on sql server by pinal dave free sql

Options

Therearethreedistinct

optionsinthe Spotlight onSQLServerFreemium tool barmenu.

Onceyouclickon

Monitoringitwillgive

you

three

options.

1)Heatmap

2)Alarms

3)Connections

SQLDBApros

6


Review of spotlight on sql server by pinal dave free sql

Heatmap

Ifourserver isdown,wewant to

know rightaway,butifeverythingis

smoothwedoneedreminders.

Forthat reasonHeatmapisan

essentialpart ofSpotlightonSQL

ServerFreemium.

Itgivesan‘at-a-glance’pictureof

the stateofallthe serversDBAshave

intheirenvironment.

Colorscommunicateallthe

informationaboutwhat isgoingon withyourserver.

Theheatmaptakes thisastep further

bydisplayingeachserver asatileand

thenaggregatingallofthe statuses ofaserver and assigningasizeto

that tile.Italsodisplays alarmsforthe connectionwhentouched.

SQLDBApros

7


Review of spotlight on sql server by pinal dave free sql

Alarms

Alarmsisjustanalternateway

toviewHeatmaps.

Theydisplay alarmsoneach serverorderedbyseverity.

Youcan configure

and sort alarmsthe wayyou prefer.

Onceanalarm ringsan

experienceduser can doone

oftwo things:

1.

Acknowledgethe alarm

and solve the issue

Snoozethe alarm and

beremindedinthe future

2.

SQLDBApros

8


Review of spotlight on sql server by pinal dave free sql

Connections

•Thisparticulararea displays various connectionstodiagnoseaserver

aswellasthe serverwhichyouaremonitoring.

•SystemHealthCheck-providesaprioritized listofthe keysystem healthissues.Users can pinpointand resolvevarious issues.Thereare

majorfivecategoriesthistool checks:

Security, Disaster

Recovery,

Index

Optimization,

Memory,

and

SQL

Best

Practice.

SQLDBApros

9


Review of spotlight on sql server by pinal dave free sql

InfutureblogpostsIwillcovereachofthesetopicsin

depth.

Meanwhile,Istronglysuggestyou download

SpotlightonSQLServerFreemiumandmake

sureyourserversarehealthy.

SQLDBApros

10


Review of spotlight on sql server by pinal dave free sql

Learn

More

ViewDave’sOriginal Post

Download

FreeTools

11


  • Login