Reporting blocked processes in SQL

Recently I’ve been working on an issue where a query was being blocked.  In order to get the specifics on this it’s possible to use the Blocked progress report in the SQL Profiler.

To do this you need to first enable advanced options by running:

SP_CONFIGURE’show advanced options’,1 ;
GO

Then run:

RECONFIGURE;
GO

After turning that one, you need to set the blocked process threshold.  This is the number of seconds between checks to see if there is blocking going on. 

SP_CONFIGURE’blocked process threshold’,10 ;
GO

This will set it for 10 seconds.  You could change it to something lower if you want.  When you are done testing you should change it back to 0 (disabled).

After setting the threshold you need to reconfigure again:

RECONFIGURE;
GO

Then pick the Blocked process report from SQL Profiler:

image

The possible values of the Mode value are:

0=NULL
1=Sch-S
2=Sch-M
3=S
4=U
5=X
6=IS
7=IU
8=IX
9=SIU
10=SIX
11=UIX
12=BU
13=RangeS-S
14=RangeS-U
15=RangeI-N
16=RangeI-S
17=RangeI-U
18=RangeI-X
19=RangeX-S
20=RangeX-U
21=RangeX-X

Procedure or function expects parameter which was not supplied.

If you are googling for this error:

“Procedure or function (name) expects parameter (@parameter) which was not supplied.”

and you are SURE that you are providing the parameter to your stored procedure call, remember that for this to work properly with ADO.NET you need to set the IDdCommand or SqlCommand CommandType to be CommandType.StoredProcedure.

image

Failed to load viewstate (when debugging)

I’m not sure of the reason, but I couldn’t find anyone else posting about this so I figured I’d put it out there incase another puzzled developer goes looking.  In an application I’m working on (that happens to use Telerik radAjaxManager for this postback) I would consistently get this error, which as many will know is something you can get if you start adding controls to the tree in a page event that happens after Init, but I wasn’t adding any controls.  Turns out that this error completely goes away if I disable my break points.  Even if I’m still debugging, but my break points are disabled, I never see this error.

image

I don’t know what’s going on but maybe someone else will see this same post and know that they are not alone. 

Visual Studio 2015 Nuget.Config repositoryPath

So it looks like VS 2015 has changed (again) how they deal with Nuget management.  Now they no longer create the .nuget folder and the nuget.config file.

We still want to make use of the respositoryPath so to do this for new solutions create in VS 2015 we need to:

  1. Create a .nuget folder in the root of the solution (on the file system)
  2. Inside that folder, create a file NuGet.config. 
  3. In Visual Studio 2015, right click on the solution and add a new solution directory called “.nuget”
  4. Right click on that folder and select to add a new an existing file and select the NuGet.config file created in (2).
  5. Add content like this inside the NuGet.config file:

<?xml version=”1.0″ encoding=”utf-8″?>
<configuration>
  <solution>
    <add key=”disableSourceControlIntegration” value=”true” />
  </solution>
  <config>
    <add key=”repositoryPath” value=”..\..\..\..\NugetPackages” />
  </config>
</configuration>

Then reboot Visual Studio and it should work.

Fixing Hyper V “VMName failed to change state” error 32788

If you find yourself getting this error message:

The application encountered an error while attempting to change the state of ‘VMName’.  ‘VMName’ failed to change state.  The operation failed with error code ‘32788.’

image

Go to the settings of your VM:

image

And look for something in an error state:

image

In this case I had changed Virtual Switch since using the VM so it’s no longer valid.

Remoting (RDP) to Azure service: This User Has Expired

If you are trying to RDP into an Azure service and you get the message “This User Has Expired” that’s because when Cloud Services are deployed, the user is only enabled for a short period of time.  If you don’t want to fully redeploy your application you can modify the expiration.

To do this, go to the service’s Configuration section and click the Download button to download the configuration file.

image

In that configuration file you’ll need to change the value for:

Microsoft.WindowsAzure.Plugins.RemoteAccess.AccountExpiration

image

Go back to the configuration page and upload this file using the Upload button.  Press Save and after a few moments it will change your user accounts expiration date.