SQL Server health check using PowerShell and T-SQL   10 comments

I am back with another interesting blog which hopefully the production DBAs would find more useful. We often have the need to capture aggregated data related to SQL Server health which can not only be captured quickly but also be able to customize as per the requirements.

We have many tools available to capture the performance data but it mostly has some data lag and does not tell us what’s currently running on the system.

Since last few days, I have been working on a script based solution which helps us to perform quick health check of our production instance to resolve any production issue with this blog, I intend to share the solution as I have found it quite useful Read the rest of this entry »

Query Store: Exploring new features in SQL Server – vNext   1 comment

Troubleshooting performance problem is one of the challenging and most often faced situation in DBA’s life. Following diagram shows three major scenarios where DBA’s get involved and spend nights troubleshooting performance problems.

Note: This is with community technical preview 2 of SQL Server 2016, things may change with the RTM release

18

Read the rest of this entry »

SSRS Reports Issue after Migration: Invalid object name ‘ReportServerTempDB.dbo.TempCatalog’   4 comments

I recently migrated one of our SQL Server Database Engine and SSRS instances from SQL Server 2008 to SQL Server 2014. Post migration, when I tried to browse the SSRS reports, I get this error:

Microsoft.ReportingServices.Diagnostics.Utilities.ReportServerStorageException: 
An error occurred within the report server database.  
This may be due to a connection failure, timeout or low disk condition within the database
. ---> System.Data.SqlClient.SqlException: 
Invalid object name 'ReportServerTempDB.dbo.TempCatalog'.
Could not use view or function 'ExtendedCatalog' because of binding errors.

Read the rest of this entry »

Powershell script to manipulate SQL Server backup files   Leave a comment

Scenario

I use Ola Hallengren’s famous backup solution to back up my SQL Server databases. The destination for full backups is a directory on local disk; let’s say D:\SQLBackup\

If you are familiar with Ola’s backup scripts, you know the full path for backup file looks something like:

D:\SQLBackup\InstanceName\DatabaseName\FULL\InstanceName_DatabaseName_FULL_yyyymmdd_hhmiss.bak

where InstanceName is a placeholder for the name of the SQL server instance, similarly, DatabaseName is for the Database Name. Read the rest of this entry »

[Part-5]Private Cloud: Some common issues and troubleshooting tips   Leave a comment

This is the fifth and final post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 Here is a list of topics for the entire series:

 

1. PrivateCloud_Icon[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In this blog I will provide some troubleshooting tips e.g. where to look in case of any error and few scenarios.

When it comes to troubleshooting, usually, the following questions comes into mind:

  1. Log files: Where and what to look at?
  2. Troubleshooting example
  3. Common issues/errors

I am going to cover the above mentioned topics in this blog post. Read the rest of this entry »

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal   1 comment

This is fourth post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP). 

Here is a list of topics for the entire series:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In this blog post, we will create a plan, assign this plan to the user and then provision a Virtual Machine and a Database.

Before we proceed, let me explain what is a plan and why do we need to assign a user to it. Read the rest of this entry »

[Part-3]Private Cloud: Install and Configure WAP   2 comments

This is third post in the series of blog posts on how to build own Private Cloud using Windows Azure Pack (WAP).

 

Here is a list of topics for the entire series:

 

[Part-1]Private Cloud: Introduction and installation of pre-requisites

[Part-2]Private Cloud: Configure SCVMM and SPF

[Part-3]Private Cloud: Install and Configure WAP

[Part-4]Private Cloud: Demo of provisioning VM and SQL DB using Tenant portal.

[Part-5]Private Cloud: Some common issues and troubleshooting tips.

 

In this blog post, we will install and configure WAP followed by configuration of SPF, SCVMM and SQL Server on WAP. I have divided it in two sections:

Section-1: Install and Configure Windows Azure Pack

  • Installing Windows Azure Pack: Online installation
  • Installing Windows Azure Pack: Offline installation
  • Configure Windows Azure Pack

Section-2: Configure SPF, SCVMM and SQL Server on Window Azure Pack

  • Configure SPF and SCVMM on Windows Azure Pack
  • Configure SQL Server on Windows Azure Pack

Read the rest of this entry »

Follow

Get every new post delivered to your Inbox.

Join 1,224 other followers