Why is affinity mask negative in sp_configure   Leave a comment


While looking at a SQL server health report, I found affinity mask parameter in sp_configure output showing a negative value.

 

name                                minimum     maximum     config_value run_value
----------------------------------- ----------- ----------- ------------ -----------
affinity mask                       -2147483648 2147483647  -1066394617  -1066394617

 

This output was from a SQL Server 2008 R2 instance running on Windows Server 2008 R2.

 

Affinity mask is a SQL Server configuration option which is used to assign processors to specific threads for improved performance. To know more about affinity mask, read this. Usually, the value for affinity mask is a positive integer (decimal format) in sp_configure. The article in previous link shows an example of binary bit mask and corresponding decimal value to be set in sp_configure. 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 http://sqlactions.com 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 sqlactions.com 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!!

 

How it Works – “LogPool”   Leave a comment


Hello all,

Today I would like to discuss about one of the new enhancements done in SQL Server 2012 called LogPool.

Before we get into the details, let me try to explain how does the log flush occur in SQL Server. When a record is inserted or modified in a database, it is first copied into the log buffer in memory, these log buffers are like log blocks of different size (512 B to 60 KB). When this buffer is full or a commit is issued these log blocks are flushed to the transaction log. Read the rest of this entry »

Extended Events unplugged   Leave a comment


Hello All,

Wish you all very happy new year 2014!!

This year we are planning to focus more on recording video blogs and in this series I decided to write my first video blog on Extended Events.

Below are the highlights of this video blog.

Agenda

Introduction to Extended Events
Why Extended Events?
When to use Extended Events?
How it works?
Demo

Highlights of Demo

New Extended Events related DMV’s
Configure an Extended Event session using GUI
How to read the XEL files.
Some special troubleshooting tips!
 
Note: Please watch this video in HD for better quality. If you wish to download, please click on  the drop menu on the top left corner of this video.  Read the rest of this entry »

Posted January 6, 2014 by Manish Upadhyay in Extended Events

Tagged with , , ,

Strange errors with SQL Server 2008 setup   Leave a comment


This is a quick post to let you know about two strange errors I recently encountered during SQL Server 2008 setup and the steps on how to resolve them.

 

1.    Installation of SQL Server client tools (SSMS) fails with this error message:

 

 

SSMS error

Read the rest of this entry »

[Part-2]Let’s drill why you “Cannot generate SSPI context”   5 comments

[Part-1]Let’s drill why you “Cannot generate SSPI context”   5 comments


When you see error “Cannot generate SSPI context” what is the first thing comes to your mind, SPN problem isn’t it?

There are many such errors which lead us to assume that we have problems with SPN. Although, it could be a correct approach, do we really try to understand how does this authentication work? Why it fails and how can we resolve such errors?

Well, I have also come across these errors numerous times and hence researched a bit deeper to find out some internals, how it works behind the scenes etc. And that calls for this two-series of blog post which will give us an insight of windows authentication process between an application and SQL Server, the related errors and their troubleshooting approach.

 As stated above, this is a two-series blog which will cover the following:

Part -1: We will discuss about how windows authentication process works in SQL Server using SSPI

Part-2: I will try to explain why this authentication fails and how to troubleshoot these issues. Read the rest of this entry »

Follow

Get every new post delivered to your Inbox.

Join 946 other followers