Continuing Series: System Center for the SQL Server DBA (SCOM Data Warehouse)

Carla Abanes:

Reblogging the part 2…

Originally posted on Blog Home for MSSQLDUDE:

Not really a new part to my multi-part series on System Center for the SQL Server DBA … I’m going to post more on the other products in the System Center Suite shortly, but I want to go back to the bread & butter tool for the SQL Server DBA in System Center: Operations Manager. OpsMgr (or SCOM) is the tool where SQL Server DBAs can view alerts, events and overall health monitoring of your entire environment including application & web monitoring, server monitoring as well as databases. With the SQL Server Management Pack add-on to SCOM, you get a large set of SQL Server counters added to your monitoring tool that you can put into dashboards and reports.

Where I want to focus today is the data warehouse feature that ships with SCOM. When events come into the SCOM server from agents, they are logged in both the operational…

View original 291 more words


System Center for the SQL Server DBA Part I: SCOM

Carla Abanes:

this is a great post for SCOM newbies like me. thank you!

Originally posted on Blog Home for MSSQLDUDE:

I’ll start part 1 of the Microsoft System Center series, focused on what a SQL Server DBA should know about System Center, with System Center Operations Manager, or SCOM, with the SQL Server Management Pack. When you have licensed the System Center suite of products, you can use these different pieces or put them together in your data centers for what we are now calling a SQL Server “private cloud” that has elastic scale, maximum server consolidation capabilities, charge back capabilities, self-service provisioning, the greatest data center economies of scale and (my favorite) load-balanced SQL Server with zero downtime configurations. The SQL Server Monitoring Pack for SCOM is downloadable here and adds a very distinctive monitoring capability to your SQL Server infrastructure. Out of the box, the SCOM SQL monitoring pack can monitor all areas of your SQL Server instances and databases by using the SCOM agent on that server…

View original 306 more words


System Center for the SQL Server DBA, cont’d SCOM Pack for SQL

Originally posted on Blog Home for MSSQLDUDE:

My original posting on System Center Operations Manager for SQL Server DBAs start in part 1 of the series here. Today, I want to take just a minute to give you some pointers in getting started using the System Center Monitoring Pack for SQL Server. Notice in that download link, that the pack has been updated to allow you to monitor up to SQL Server 2012, which now also includes monitoring your Always On Availability Groups from SCOM, a very important new feature.

One thing that I always mention to DBAs or other IT professionals who are new to using the SCOM SQL monitoring pack is to start by downloading and taking a look at the online guide for the MP: http://download.microsoft.com/download/0/7/7/07714012-3B7C-4691-9F2B-7ADE4188E552/SQLServerMPGuide.doc.

There is a LOT in there. This is good. As a DBA and someone responsible for SQL Server database health, you want a lot of monitoring…

View original 173 more words


SQL SERVER – FIX – The database ‘model’ is marked RESTORING and is in a state that does not allow recovery to be run

Originally posted on Journey to SQL Authority with Pinal Dave:

The best way one can learn SQL Server is by trying out things on their own and I am no different. I constantly am trying to explore the various options one can use when working with SQL Server. In the same context, when I was playing around with backup restore commands, I made a mistake and unfortunately restarted SQL Server. After that I was unable to start SQL Service.  If I start the service, it doesn’t give any error but gets stop automatically.

Whenever I have any weird problems with SQL, I always look at ERRORLOG files for that instance. If you don’t know the location of Errorlog, you should refer Balmukund’s blog (Help : Where is SQL Server ErrorLog?)

This is what I found in ERROLROG just before the stop.

2014-10-28 002039.02 spid9s      Starting up database 'model'.2014-10-28 002040.01 spid9s      The database 'model' is marked RESTORING and…

View original 509 more words


Giving away FREE Access to my SQL Server High Availability and Disaster Recovery Deep Dive Course – Round 2

Originally posted on - Microsoft technologies and what I do for fun -:

TwitterPromo2

Last year, as part of launching my very first online course, I gave away FREE access to my SQL Server High Availability and Disaster Recovery Deep Dive Course. I’m doing it again this year but with a totally different reason. Here’s why.

I’ve been very active in the SQL Server community in one way or another. A lot of people ask me why I do what I do. It all started in late 1999 when, fresh out of college with no one wanting to hire me, a potential customer asked me to write an inventory application for their small business. This might sound really exciting for somebody who would consider this their very first consulting opportunity immediately out of college. This plus considering the fact that my potential customer was willing to pay me any price I would charge them for it. But not for me. You see, I didn’t have…

View original 766 more words


My Time to Travel

The travels of an old(er), solo, female traveler

Blog Home for MSSQLDUDE

The life of a data geek

unfoldthecreativity

Traveller Observer

The SQL Pro

(Ayman El-Ghazali - www.thesqlpro.com)

Meels on Wheels

Meels for breakfast, lunch and dinner.

juliansherman

Just another WordPress.com site

Paul Turley's SQL Server BI Blog

sharing my experiences with SQL Server BI, Data Modeling, SSAS Design, Power Pivot, Power BI, SSRS Advanced Design, Dashboards & Visualization

TroubleshootingSQL

Explaining the bits and bytes of SQL Server and Azure

Coding Tips

We will improve your knowledge

SQL Studies

 Live, Learn, Share

Hemlock Time

Be an Author, Publisher, and Entrepreneur

Sql And Me

My Experiments with SQLServer

Dimitrios Kalemis

I am exactly like Jesus Christ: an atheist and anarchist against society and bad people with influence and power (judges, social workers, politicians, priests, and teachers).

Clint Huijbers' Blog

Senior Certified Microsoft BI Consultant

Blog of Many Useless Wonders

Where Uselessness Abounds!

Stevespevack's Blog

IT Recruitment

SQL Problems and Solutions

Sharing the knowledge & experience of SQL, DBA & BI

Glenn Berry's SQL Server Performance

Semi-random musings about SQL Server performance

Follow

Get every new post delivered to your Inbox.

Join 48 other followers