[EN] Sunday Market–SSMS Spotlight Plugin by Dell (part one)

It Sunday again. And some shops are closed. If Yes, it’s time to get next useful tool for free. It’s my episode #07 in non-frequently series: Sunday Market. This time we will look for Dell. Inspired by online session of my good friend from England: Richard Douglas {TWITTER|BLOG|LINKEDIN} I want look for Spotlight Essentials Plugin by Dell. Richard delivered session: Wait Watchers – No pain, all gain exercises to increase database performance at PASS Database Administration Virtual Chapter and it was very interesting. Interesting enough to look for this plugin. It is free, so we can get in on Sunday, just like today. This post will be divided in two parts: one for basic installation – till the moment “"’I got it!’ and second with more configuration options. So let’s install this plugin.

Phase One. Getting the plugin.

You should go to Spotlight Plugin site: https://www.spotlightessentials.com/sql-server/instances 

Captura_Spotlight01

Pict. 01 | Intoructionary picture of plugin

Captura_Spotlight02

Pict. 02 | Registration form for account using Spotlight in future

Captura_Spotlight03

Pict. 03 | Downloading plugin (ca 70 MB)

Captura_Spotlight04

Pict. 04 | Registration for Spotlight Essential Web Account (if you registered before new geristration is not necessary)

 

Phase Two. Installation of plugin.

Captura_Spotlight05

Pict. 05 | Welcome screen (same type like Visual Studio 2013 isn’t?)

Captura_Spotlight06

Pict. 06 | Transaction Product Agreement – in normal words license.

Captura_Spotlight07

Pict. 07 | Installation of Diagnostic Server with specify Diagnostic Server Service Account

Captura_Spotlight08

Pict. 08 | Using special dedicated account SQL Spotlight will bring errors with permissions, but it work and is best way in my opinion.

Captura_Spotlight09

Pict. 09 | Configuration os specific Payback Database which will store recent and current data (we can choose special instance or the same instance as production server)

Captura_Spotlight10

Pict. 10 | If desired instance are not connected or not running, we will get error.

Captura_Spotlight11

Pict. 11 | In the case of clicking NEXT at previous screen we will get error that Specific Database not exist

Captura_Spotlight12

Pict. 12 | When we click CREATE on screen (at picture nine) we can creat Specific Database

Captura_Spotlight13

Pict. 13 | Specific Database created succesfully

Captura_Spotlight14

Pict. 14 | Installaton started…

Captura_Spotlight15

Pict. 15 | …and finished. Aproximately time is less than five minutes.

 

Phase Three. First view in SQL Server Management Studio.

Captura_Spotlight16

Pict. 16 | Specified Database appears in databases tree: SpotlightPluginPlayBackDatabase

Captura_Spotlight17

Pict. 17 | We can docking Spotlight Plugin in a tab. But we can’t connect to Diagnostic Server if our Spotlight plug-in Diagnostic Server Service didn’t run.

Captura_Spotlight18

Pict. 18 | We can check Services and even we see that service is running, we can STOP and START again it.

Captura_Spotlight19

Pict. 19 | First view for our plugin in General Tab

Captura_Spotlight20

Pict. 20 | Next step is connecting instance to Spotlight Essential Plug-In Web Account (I will write more about in in next post)

Captura_Spotlight21

Pict. 21 | Time for connect first instance. In my case is the instance with Specified Database

Captura_Spotlight22

Pict. 22 | And here we see status of connections: to Diagnostic Server and to Instance

Captura_Spotlight23

Pict. 23 | First detailed tab: Overview Tab with Waits, Top Databases Files IO, Batch Request, Summary, Connections, CPU Usage and more.

Captura_Spotlight24

Pict. 24 | Second detailed tab: Sessions with sessions status, activity last command and over thirty other details about sessions

Captura_Spotlight25

Pict. 25 | Third detailed tab: Resources Waits with Wait Time Trend ans Waits Details

Captura_Spotlight26

Pict. 26 | Fourth detailed tab: Data File I/OS with general data file infor for each data file and system databases

Captura_Spotlight27

Pict. 27 | Fifth  detailed tab: TOP SQL  with detailed information about last TOP 25 SQL Queries

Captura_Spotlight28

Pict. 28 | After few minutes of work we can see more events on our General Tab where alarms are sorted by Severity

Captura_Spotlight29

Pict. 29 | And more and more alerst after next few minutes.

Screenshot 2015-01-04 18.17.01

Pict. 30 | We can add more instances for Diagnostic Server

Captura_Spotlight30

Pict. 31 | But we can’t connect with SQL Azure Instance if we just click without changing authentication type

image

Pict. 32 | When we use SQL Authentication, connection is succesful

image

Pict. 33 | And we can see all instances in General Tab

Captura_Spotlight31

Pict. 34 | In General Tab we see status of our instances in colors which based on health status

Screenshot 2015-01-04 18.47.05

Pict. 35 | When we move mouse in General Tab over one of many instances we will see pop-up windows with short information of errors

Screenshot 2015-01-04 18.48.51

Pict. 36 | And those errors will be different, they change in time

Screenshot 2015-01-04 19.01.23

Pict. 37 | Same pop-up windows we will see in Overview tab on each instance

 

That’s All Folks. Get the plugin, istall the plugin and configure the plugin. From this point You can test this plugin and start to play with this nice tool. More details about configuration, errors, connections and how useful this plugin could be in next post.

[EN] SQL Azure PASS Virtual Chapter January Meeting

LOGO_SQL-Azure_rgb

I’m happy to announce our new virtual meeting. From beginning of 2011 we decided to have meeting on the second Wednesday of every month. In January release we’ll talking about SQL Azure Performence:

The presentation will focus on various aspects of performance and scalability of SQL Azure, including the importance of connection pooling, data federation, performance measures and more.

This time our speaker is: Herver Rogerro – is the founder of Pyn Logic (a company focusing on advanced SQL Server security) and Blue Syntax Consulting (a company focusing on Azure Consulting and Training). Herve’s experience includes software development, architecture, database administration and senior management with both global corporations and startup companies. Herve is a member of the ISSA. He holds multiple certifications, including an MCDBA, MCSE, MCSD. He also holds an MBA from Indiana University. Herve is heavily involved with the South Florida SQL Server community, speaks at multiple venues, co-authored Pro SQL Azure and runs SQL Saturday events in South Florida.

Herve blogs here and you can reach him on Twitter here

Last important information – date:
Wednesday, January, 12, 2011 12:00 PT (20:00 GMT)

More information and link for Live Meeting (will be posted shortly) HERE

[EN] 1st PASS SQL Azure Virtual Chapter Meeting

LOGO_SQLAzure_rgbToday is the DAY. Based on request from PASS members we starting with PASS SQL Azure Virtual Chapter. The goal of this VC is to make it one of the best online resources to get to know the anything and most everything about SQL Azure.  We have meetings on the second Wednesday of every other month.  Our group meets online via Netmeeting and can be attended from anywhere in the world.

Our first meeting will start at 03:00 PM PST [11:00 PM GMT].

Today You have a chance to meet two fantastic persons:

our host Scott Klein (SQL Server MVP) who will introduce to SQL Azure Chapter, and

our guest (today from Melbourne): David Robinson  he will presenting session “Introduction to SQL Azure (level 100)

Session Abstract:
Microsoft SQL Azure Database is a cloud-based relational database service built on SQL Server technologies. It provides a highly available, scalable, multi-tenant database service hosted by Microsoft in the cloud. SQL Azure Database helps to ease provisioning and deployment of multiple databases. Join us as we introduce you to the SQL Azure world and help you to understand the benefits that it can provide.

Speaker Bio:
Scott Klein
is co-founder of Blue Syntax Consulting, a company that specializes in Azure training and consulting. Scott has been working with SQL Server for nearly 20 years, working with companies large and small all over the United States, working in a wide scope of fields such as medical, finance, and retail. Scott is also a veteran author, having written a number of books including Professional SQL Server XML, Professional LINQ, Pro ADO.NET Entity Framework 4.0, and the soon to be released Pro SQL Azure. Scott is a SQL Server MVP and President of the South Florida SQL Server Users Group and the newly formed Azure PASS Virtual Chapter. He speaks frequently as SQL Saturday events and user groups, and was lucky enough to speak at the 2008 European PASS conference in 2008.

David Robinson is a Senior Program Manager on the SQL Azure team. David is responsible for a multitude of things including driving product features, code samples, and most importantly demonstrating to customers the value that SQL Azure and cloud computing provides.  You can often find him speaking on Channel 9 or TechEd.

All details and registration HERE