SQl Server Blocking Detection

http://www.sqlservercentral.com/articles/deadlock/71374/

Easy process to run in the background

Tools: Network: Fling

Look@Lan has been updated

http://www.over-look.com

SQl Server Blocking Detection

here is a good script that can be run when a SQL block occurs.

http://blog.sqlauthority.com/2010/10/06/sql-server-quickest-way-to-identify-blocking-query-and-resolution-dirty-solution/



SELECT
db.name DBName,
tl.request_session_id,
wt.blocking_session_id,
OBJECT_NAME(p.OBJECT_ID) BlockedObjectName,
tl.resource_type,
h1.TEXT AS RequestingText,
h2.TEXT AS BlockingTest,
tl.request_mode
FROM sys.dm_tran_locks AS tl
INNER JOIN sys.databases db ON db.database_id = tl.resource_database_id
INNER JOIN sys.dm_os_waiting_tasks AS wt ON tl.lock_owner_address = wt.resource_address
INNER JOIN sys.partitions AS p ON p.hobt_id = tl.resource_associated_entity_id
INNER JOIN sys.dm_exec_connections ec1 ON ec1.session_id = tl.request_session_id
INNER JOIN sys.dm_exec_connections ec2 ON ec2.session_id = wt.blocking_session_id
CROSS APPLY sys.dm_exec_sql_text(ec1.most_recent_sql_handle) AS h1
CROSS APPLY sys.dm_exec_sql_text(ec2.most_recent_sql_handle) AS h2
GO

The fire

We have not put the heating on yet. We have been enjoying the fire. Very nice

How to transfer filezilla server settings

You can easily trasfer all settings from one filezilla server to another by copying the filezilla server.xml from one server to another

stop filezilla server
copy in filezilla server.xml
start filezilla server

How to check for a postmaster in Exchange 2007

http://www.petri.co.il/creating-a-postmaster-mailbox-in-exchange-server-2007.htm

Servers:2008:IIS7:urlrewrite

http://learn.iis.net/page.aspx/803/using-custom-rewrite-providers-with-url-rewrite-module/

Servers:2008:IIS7:mem leak

Every so often 4-6 months
    There is a memory leek in the NPP memory pool at a customer server which causes a IIS to stop responding.

The easiest resolution  is to reboot the server.

Lots of extra analysis would need to be performed to find the root cause. i.e the driver which is causing the memory leek.


The symptoms are

1, Around every 4-6 months the IIS service on the server stops responding. The only way to resolve is to reboot the server.
2, From investigation IIS uses a  NPP Kernal memory. This is used by other drivers on the server. If this runs out IIS will stop responding and will put a message into the http error log ‘connection refused’.
3. Even through all the services connected to IIS are restarted the site still does not respond. This points to a memory leek.
4, IIS uses HTTP.SYS in the NPP memory. Another process is hogging all the memory – used it up. HTTP.SYS needs to use that memory to handle connections.

There are two resolutions to this problem.

1, Automate a reboot of the server every weekend when no one is using it. This will clear out the NPP memory. This assumes the problem driver or process slowly increases it memory usage over time
2, Run through the articles below, find the driver/process, try updating it or remove the program.

KB 177415 - How to Use Memory Pool Monitor (Poolmon.exe) to Troubleshoot Kernel Mode Memory Leaks – http://support.microsoft.com/?id=177415
KB 298102 - How to Find Pool Tags that are used by Third-Party Drivers – http://support.microsoft.com/?id=298102

Ground Prep Round 2

After a nice lunch Linda, my mum Hazel, Sandra and Eddie helped with the work. The gooseburry bush snatched Sandra's glasses; we spent the next 30 minutes looking for them. Turned up hanging on the same bush; good job Eddie found them. I'm not sure the goosebury bush really needed them!

Prep-ing the ground ready for planting. I found where some of the lady birds are. It's not easy to see  - they are all huddled together. One more rake over to remove the last of the weeds and we will be ready to plant.

Some of the veg we had for lunch was from the harvest from last year.






'Hello'
- Posted using BlogPress from my iPhone







There are about 6 ladybirds huddled together in this curled up leaf






You can see one of them if you look closer. They will do a good job once the veg is growing.






You may be able to zoom in and see all of them







These will very tasty in a crumble.






Looks better after a good weed







This is what is looks like now. Will be very different in a few weeks






Ah, another batch of rhubarb. Planted this one last year and is already taking off. We planted another crown next to this one a few weeks ago. Will add mass to the group; team work.







This will look really good in a few weeks






Spinich and asparagus






This is going to be a a new raised salad bed. One of my fences blew down during the winter. This is going to be used to make the frame.

Digging over

Made a flask and went to the veg path with Sandra.We worked really hard preparing the ground ready for planting.

Here are the results.


- Posted using BlogPress from my iPhone

SAN:Storage area networks

I have been researching this area for some time. Deciding on which one we will go for is not an easy decision. It is important to understand the options and where you are now.


- Posted using BlogPress from my iPhone

Clearing up starts

Started the first clean up of the year. There were plenty of places to hide and a bit of food for the insects.














Ah the lady birds are still about

Rocky relaxing

- Posted using BlogPress from my iPhone

List of mine types

http://www.hosting.com/support/dedicated/iis/mimetypes/

IIS 7 mine types

How to add mine types and IIS7
http://blogs.iis.net/bills/archive/2008/03/25/how-to-add-mime-types-with-iis7-web-config.aspx