Archive for the ‘sql server’ Tag

SQL Server health check using PowerShell and T-SQL   15 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 »

We didn’t know that   Leave a comment

When we setup this blog, we didn’t know that this very first post will be so popular that it will alone have one-third of the total views on the site, that it will rank# 1 in the major search engines (as of today), see here and here. And we didn’t know that it has been **two wonderful years**, it just feels like yesterday that we setup this blog. Time flies! J

Yes, we are celebrating two years of today, April 15th 2014. On behalf of the authors of sqlactions Manish, Karthic and Prashant, we would like to thank all our blog readers for the continued support. The increased no. of site views and followers, the technical discussion thru blog comments and some readers contacting us for their urgent productions issues… all have been phenomenal in the past two years.

As we go on this journey of SQL Server, we promise to publish the same quality blogs, covering more topics, latest versions and more of video blogs. If there is any special topic you would like us to blog about, please feel free to contact us.

To cherish the moment, here are top 10 blogs on which were most viewed and most popular so far.

  1. Collection and Reporting of Perfmon data for SQL Server “Capacity Planning” and “Trend Analysis”
  2. Automated Reports for SQL Server Perfmon data
  3. How to create custom schedule for SQL Server Agent Job
  4. A read operation on a large object failed while sending data to the client
  5. SQL Agent Job reports error “SQLServerAgent is not currently running ” Though Agent Service is running
  6. Part-1 How to build SQL Server Failover Cluster Lab on Windows 8 – Also see part-2 and part-3
  7. DBCC MEMORYSTATUS : How is Stolen Potential calculated
  8. Latch Timeout: To worry or not to?
  9. Simple backup Strategy for Distribution database
  10. [Part-1]Let’s drill why you “Cannot generate SSPI context” – Also see part-2

Happy reading!!


Posted April 15, 2014 by Prashant Kumar in Celebration

Tagged with , , , ,

How do I login to SQL Server from different domain without logon rights   5 comments

SQL 2008 setup rule “Not clustered or the cluster service is up and online” Failed   6 comments

Hi all,

I am back again with another interesting issue.

We had a situation last week where we had to un-install a service pack from one of our production environment as a part of change back out plan.

Though the plan looks very simple as MS has provided a very good functionality of removing it from add and remove programs.

Just go to add and remove programs, select check box “show updates” or got to “installed an update” select the service pack which you want to remove and we are done!!

Read the rest of this entry »

SQL Server 2008 backup hung on a strange wait PREEMPTIVE_CLUSAPI_CLUSTERRESOURCECONTROL   Leave a comment

This is another interesting case where SQL Server 2008 backup appears to be hung. The client reported that he has a maintenance plan to take full backup of all the user databases. Apparently backup for some of the databases succeed while for some other the backup just ‘hangs’. At times, SQL Server reports non-yielding scheduler and generates a stack dump as well.

Read the rest of this entry »

.Net CLR assembly and stack dump and SQL Crash…   2 comments

This post is a result of another thread on MSDN forums I answered the other day. I thought to blog about it from a SQL perspective. SQL Server 2005 SP3 x64 crashes generating a stack dump.

<Date Time> spidxx       Using ‘dbghelp.dll’ version ‘4.0.5’

<Date Time> spidxx       **Dump thread – spid = xx, PSS = 0x0000000080A23F10, EC = 0x0000000080A23F20

<Date Time> spidxx       ***Stack Dump being sent to C:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\LOG\SQLDump0023.txt

<Date Time> spidxx       * *******************************************************************************

<Date Time> spidxx       *

<Date Time> spidxx       * BEGIN STACK DUMP:

<Date Time> spidxx       *   08/14/12 14:16:11 spid xx

<Date Time> spidxx       *

<Date Time> spidxx       * A fatal error occurred in .NET Framework runtime.

<Date Time> spidxx       *

<Date Time> spidxx       * Input Buffer 86 bytes –

<Date Time> spidxx       *             [dbo].[My_sproc]’P1′

Read the rest of this entry »