collecting performance data for SQL Server via Powershell

Performance Monitor is a Windowds-based tool which has also very effective counters for SQL Server. There are various methods to collect performance data like typeperf (http://technet.microsoft.com/en-us/library/bb490960.aspx) and creating data collector sets (http://technet.microsoft.com/en-us/library/cc722414.aspx). Another method is using Powershell script. Here you go with the script: #In do-while loop, you can define how many times you would…

9

how to manage your SQL Servers with Central Mangement Server and Powershell

  One of the features I like most with 2008 is Central Management Server. CMS introduces us with multi server management. However, it only shows the results in SSMS and does not save the result set.  To get the result set in a SQL Server table, the only thing you need is a handy Power…

8

differences between quorum models in windows 2003, 2008, 2008R2, 2012 and 2012 R2

In this blog post, the differences between the quorum models for Windows Server Clusters 2003, 2008, 2008R2, 2012 and 2012 R2 will be clarified. The basic idea of a server cluster is physical servers acting as a virtual server, so  it is critical that each of the physical servers have a consistent view of how…

3

Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 3

Time is automating data collection now. It is nothing but just a SQL Server agent job. After going through the usual steps while defining a SQL Agent job, the important thing is choosing “PowerShell” as type on “New Job Step” dialog. And as a command you should type the same command as you configured before…

2

Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 1

Nowadays, one of my trendy topics @my customers is multi server management. I will make a few blog posts regarding on this topic. Firstly, even though it is very basic I will start with Central Management Server and Policy Based Management, and then merge them with Reporting Services. I will mainly refer http://epmframework.codeplex.com/ during these…

1

how to find long-running queries and send as an email

Long running queries for SQL Server can cause many problems and it is deadly important to find them and to be informed when something goes wrong. Let’s assume that we would like to tune queries lasting more than 60 seconds. We will pass duration as a parameter and you can adapt it to your environment…


Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 2

Collection of Evaluated Policies: To collect results, firstly of course we need a database. But, don’t worry about that actually it is the easiest part since we have a ready script for that. The only thing you need to do is downloading EPMFramework from the link http://epmframework.codeplex.com/releases/view/28621 I haven’t changed the default download path and…


checking the status of SQL services and databases on multiserver environment

If you have only one SQL Server to check, it is quite straightforward to check the status of services and databases. When you have dozens of SQL servers, I am sure you don’t want to spend several hours just for a basic control.  To monitor the SQL services (SQL server service and SQL agent service,…


Managing SQL Servers in multi-server environment via Central Management Server, Policy Management, Power Shell and Reporting Services – 4

And now, our last blog post on these series. I will continue with another series on this topic. This time with my custom scripts and custom reports. Just keep in touch J We are going to visualize our results now. How? We are going to use Reporting Services. If you are not familiar please don’t…


how to collect data for troubleshooting SQL Servers via sqldiag

Nowadays, I am reviewing the tools for troubleshooting SQL Servers since I will deliver a training in Dublin next week. While reviewing them, i would like to summarize them with a blog series. Now, first one is SQLDiag. SQLDiag is a general purpose diagnostics utility that can collect the following types of diagnostic information: Windows…