Review of Spotlight on SQL Server by Pinal Dave

Views:
 
     
 

Presentation Description

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

Comments

Presentation Transcript

PowerPoint Presentation:

Review of Spotlight on SQL S erver – FREE S QL Server Tools Pinal Dave SQL Serv e r Profes s ional Profuse SQL Writer SQL Se r ver D B A P r o f essionals G lo bal Ma rk e t i ng

PowerPoint Presentation:

This review is ba s ed on the FREE S QL Server performance monitoring tool: Spotlight on SQL Se r ver. 2 S Q L D BAp ro s

PowerPoint Presentation:

l ife goal…. A DBA’s If you think of a D B A's lif e , it has one ve r y simple goal - their se r ver should nev e r go down and all the q u e r ies should always p e r f orm e x ce l l e ntl y . Howev e r , just like any other life goals, it is not possib l e to ach i eve that easily. I oft e n see D B A 's cont i nuous l y wat c hing their monit o r to ma k e su r e that their se r ve r s a r e r unning f ine. Another habit of most D B As is to cont i nuous l y check their mobile phone f or ale r ts. Nowada y s we g et so many al e r ts its g e tting ha r d e r to k e e p watch on the most i mpo r tant ones. M a ny cont i nue to sea r ch at home to c at c h sus p i c ious ale r ts. 3 S Q L D BAp ro s

PowerPoint Presentation:

SQL PASS 2013 Ea r lier this y e ar, when I a tten d ed SQL PASS 2 0 13, I sto p p e d by the Dell booth to see what th e y have new in the SQL Se r ver worl d . I noti c ed Spotlight on SQL Se r ver Fr e emium r u nning on their monit o r. W hen I i nq u i r ed about the p r i c e, I as it w as totally FREE! was hap p y , in fact I w as ve r y hap p y I r ecent l y I got some time and I downloaded the Spotlight on SQL Se r ver F r e e mium FREE tool. 4 S Q L D BAp ro s

PowerPoint Presentation:

In s t a l l a t ion • The inst a llation w a s straight fo r ward and eas y . • It took less than 10 s e conds to install the tool. • On c e I installed the p l u g -in, it was ve r y easy to use it as i t b e comes an inte g r al pa r t of the SQL Se r ver M a nagem e nt Studio. • The inter f ace is ve r y us e r f r iend l y. 5 S Q L D BAp ro s

PowerPoint Presentation:

Opti o ns Th e re are thr e e distin c t options i n the Spotlight on SQL Se r ver Fr e emium tool bar menu. On c e y ou cli c k on M o nitoring it w ill give you thr e e option s . 1) H eat m ap 2) Ala r ms 3) C o nnec t ions 6 S Q L D BAp ro s

PowerPoint Presentation:

Hea t map • If o ur s e r v e r is do w n, we w ant t o kn o w right awa y , b u t if e v e r y t hi n g is sm o o t h w e do n ee d r e mi n ders. • For t hat r e ason H e at m ap is an e ss e n t ial p a rt of S pot l ight on S QL Se r v e r Fr ee miu m . • It g ives an ‘ a t - a -g lanc e ’ pictu r e of t he s t ate o f all t he s e r v e rs D BAs ha v e in t h e ir e nvi r o n m e n t . • C o l o rs co m munica t e all t he informati o n a b out w hat is going on w i t h your s e r v e r . • T he h e at m ap t a k e s t his a s te p furth e r by displa y ing e ach s e r v e r as a t ile and t h e n a gg r e g at i n g all of t he s t atus e s of a s e r v e r and assigning a si z e t o t hat t il e . It also dis p lays ala r ms f or t he con ne c t i o n w h e n t ouch e d. 7 S Q L D BAp ro s

PowerPoint Presentation:

A l arms • Alarms is j ust an alte r nate way to v i ew H e atm a ps. T hey disp l ay alarms on each se r ver o r d e r ed by sev e rit y . Y ou can con f igu r e and sort alarms the way you p r e f e r . On c e an alarm r ings an e x p e r ienc e d us e r can do o n e of two things: • • • 1. A c kn o wle d ge the alarm and so l ve the is s ue Sno oz e the alarm and b e r emin d ed in the fu t u r e 2. 8 S Q L D BAp ro s

PowerPoint Presentation:

Con n ecti o ns • T his pa r ticular a r ea d isp l ays va r ious conn e ctions to diagno s e a se r v e r as well as the se r ver whi c h you a r e monitoring. • Sy s t e m Hea l th Ch e ck - p r ovides a p r ioriti z ed list of the k ey syst e m health issues. Use r s can p inpoint and r esolve various issues. T he r e a r e ma j or five ca t e g ories this tool checks: Secu r it y , D i saster Recove r y , Ind e x Opti m izat i on, M emor y , and SQL Best Pract i ce. 9 S Q L D BAp ro s

PowerPoint Presentation:

I n fut u re blog p o sts I will cov e r e a ch of th e se top i cs in d e pth. Meanwhil e , I str o ngly sugg e st you downlo a d Spotli g ht on SQL Serv e r Fre e mi u m and make sure your s e rvers are healthy. 10 S Q L D BAp ro s

PowerPoint Presentation:

Lea r n More View Dave’s Original Post Down l oad Free Too l s 11

authorStream Live Help