John Saunders's questions

I had a situation where an application was "hanging" in accessing the database. I was able to see that there was a connection by using

Get-NetTcpConnection -RemotePort x

This showed that there was an established connection, which is a Good Thing. However, I'd like to determine whether any traffic is flowing over that connection. Is there a way to do that in PowerShell, either by using a cmdlet or by using CIM?

An answer for Windows 10/Windows Server 2012 and above would be great, using PowerShell 5 or 7.

I have a number of applications currently running on a Windows Server 2003 system. We'd like to migrate one of those applications to IIS7 on a Windows Server 2008 R2 box. This is a new web server, has IIS installed, but nothing else.

I know how to migrate the entire server, and even the entire site, but how do I migrate the server-wide settings, the site-wide settings, the app pool used by the application and then the application itself?

I'm running Windows 7 Professional.

I know how to get a list of all the users in a group:

$ou="User Groups"
$userADName="RRAS VPN SSL"
$userADPath="LDAP://proddc6.prod.root/CN="+$userADName+",OU="+$ou+",DC=prod,DC=root"
$user = [adsi] $userADPath
$user.Member

I tried iterating over that list, creating an [adsi] object for each:

$ou="User Groups"
$userADName="RRAS VPN SSL"
$userADPath="LDAP://proddc6.prod.root/CN="+$userADName+",OU="+$ou+",DC=prod,DC=root"
$user = [adsi] $userADPath
$user.Member| ForEach-Object {[adsi] ("ldap://proddc6.prod.root/" + $_)}

I was thinking of looping over the list of objects and fetching the email address and full name, then running some commands using that information. Instead, this produces the error:

The following exception occurred while retrieving member "PSComputerName": "Unknown error (0x80005000)"
    + CategoryInfo          : NotSpecified: (:) [format-default], ExtendedTypeSystemException
    + FullyQualifiedErrorId : CatchFromBaseGetMember,Microsoft.PowerShell.Commands.FormatDefaultCommand

How can I iterate over the list of users in a group, processing the email address and full name for each user?

We just had a situation where someone performed a deployment into the wrong system at the wrong time, yet nobody knows who did it, or when.

I looked in the Windows Event Logs on the target web server, and saw nothing that seemed to be from MSDEPLOY. Is there some kind of log? Even a log that just says, "a sync was performed at time by user"?

If there is no log, is there something I can do to force a log entry of some kind? For instance, is there a provider for writing event log entries, or one I can use to write to a file? I suppose I could run a script that would do some form of logging, but can the script be included in the package?

Sorry for all the questions, but this became a hot topic today!

Note that I want a log on the target web server. Either a log file, or an event log entry, but something for audit purposes that says "John deployed something at some time".

I am using Windows Server 2008, running in a Hyper-V VM. The system performs very badly. We're pretty sure it's due to insufficient memory. I've looked at How to find out if my Windows Server 2003 needs more memory?, and I'm pretty sure from seeing > 300 pages input per second, that memory is the issue.

However, I'm asking a broader question. I'd like to focus the attention of Management on the amount of time that's being wasted while waiting for these page faults. Is there a way to determine how much time is being spent waiting on paging or other resources? I'm especially interested in time spent by interactive users, but a number that includes non-interactive use would also be helpful.

To clarify, so this seems less like whining:

This system is so slow that it has taken literally minutes, while one notepad.exe window was active, to activate a second notepad.exe window that was already open and displaying. That's just activation. The performance isn't slightly bad. I think it amounts to tens of man-hours per day wasted.

I'm looking for a way to make it clear to Management how much time is being wasted. This is happening at a time when we don't actually have ten man-hours to waste.

Sorry I didn't provide more detail.

This server is being used in SharePoint (WSS 3.0) development. It is running IIS 7 set up with at least one Application Pool per developer. Each developer has one or more web applications, each set up in an AppPool assigned to that developers credentials. We're running Visual Studio 2008 SP1 and SQL Server 2008. The SQL Server data is on a separate virtual disk from the OS.

I've seen up to 8 developers on the system at once. The server is configured with 2GB of RAM, and more RAM is not trivial at this time, due to limitations of the host computer. I hope that this will get corrected if I can present enough reason to correct it, in the form of: this is how much time was wasted.

EDIT

Thanks for the answers and comments. I agree with the solution - get the SharePoint load onto a 4-8GB server, and move SQL Server onto a second one, with 2-4GB.

But my question is more like: are there any performance counters or tools that can tell me the amount of time spent waiting for page reads and writes? Any that can tell me amount of time spent waiting on queued disk I/O?

It's possible to get performance counters like "Pages input per second", but it's harder to say what values of that counter is "too much". It would be better for my purpose if there were "counters" that can say how much time is being spent because of the pages input per second.

From the questions on StackOverflow and elsewhere, I notice that there are still people using SQL Server 2000. To be honest, the greatest effect on me is that I have to remember how we used to do things without Common Table Expressions.

Still, I'd like to know if there are actual reasons (beyond "it ain't broken") to still use SQL Server 2000. For instance, I know there are people who have to use .NET 1.1 because they have to support Windows 2000 systems. Are there any similar, practical reasons to not upgrade a SQL Server 2000 system to SQL Server 2008 or 2005?