1 / 11

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

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

SQLDBApros
Download Presentation

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

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ReviewofSpotlighton SQL Server – FREE SQL ServerTools PinalDave SQLServer Professional ProfuseSQLWriter SQLServerDBAProfessionals Global Marketing

  2. Thisreviewisbased onthe FREESQLServer performancemonitoring tool: Spotlight on SQL Server. SQLDBApros 2

  3. 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

  4. 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

  5. Installation • Theinstallationwasstraight forwardand easy. • Ittooklessthan10secondsto installthe tool. • OnceIinstalledthe plug-in,it wasveryeasytouse itasit becomesanintegralpartofthe SQLServerManagementStudio. • Theinterfaceisveryuser friendly. SQLDBApros 5

  6. Options Therearethreedistinct optionsinthe Spotlight onSQLServerFreemium tool barmenu. Onceyouclickon Monitoringitwillgive you three options. 1)Heatmap 2)Alarms 3)Connections SQLDBApros 6

  7. 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

  8. 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

  9. 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

  10. InfutureblogpostsIwillcovereachofthesetopicsin depth. Meanwhile,Istronglysuggestyou download SpotlightonSQLServerFreemiumandmake sureyourserversarehealthy. SQLDBApros 10

  11. Learn More ViewDave’sOriginal Post Download FreeTools 11

More Related