Home / user-7934

Chad Miller's questions

Martin Hope
Chad Miller
Asked: 2010-08-10 11:33:50 +0800 CST
  • 8

I can't seem to get my scripts to sign in PowerShell. I have a valid code signing cert installed on my machine and run the following commands. Any suggestions?

PS C:\Users\u00\bin> $cert = @(Get-ChildItem cert:\CurrentUser\My -codesigning)[0]
PS C:\Users\u00\bin> $cert | fl


Subject      : [email protected], CN=contoso , OU=Operations, O=contoso,
               L=Mayberry, S=Florida, C=US
Issuer       : CN=contoso Intermediate CA1, DC=contoso, DC=com
Thumbprint   : XXXXXXXXXXXXXXXXXXXXX
FriendlyName : contoso 
NotBefore    : 7/20/2010 12:58:55 AM
NotAfter     : 7/20/2011 12:58:55 AM
Extensions   : {System.Security.Cryptography.Oid, System.Security.Cryptography.Oid, System.Security.Cryptography.Oi
               ystem.Security.Cryptography.Oid...}



PS C:\Users\u00\bin> Set-AuthenticodeSignature .\testsign.ps1 -Certificate $cert


    Directory: C:\Users\u00\bin


SignerCertificate                         Status                                 Path
-----------------                         ------                                 ----
                                          UnknownError                           testsign.ps1


PS C:\Users\u00\bin> Get-AuthenticodeSignature .\testsign.ps1

    Directory: C:\Users\u00\bin


SignerCertificate                         Status                                 Path
-----------------                         ------                                 ----
                                          NotSigned                              testsign.ps1
powershell
Martin Hope
Chad Miller
Asked: 2009-10-14 12:52:20 +0800 CST
  • 1

SCOM 2007 R2 added a fragmentation analsysis health check that is producing warnings on many of my servers. To try to understand how SCOM is determines the fragmentation level, I created the following Powershell script that reproduces the same data:

$vols = Get-WmiObject -computername "Z002" Win32_Volume -filter "DriveType=3"
$defragInfo = $vols | %{$_.DefragAnalysis() | add-member -membertype noteproperty vname $_.name -passThru}
$defragInfo | %{$_.DefragAnalysis | add-member -membertype noteproperty DefragRecommended $_.DefragRecommended -passThru | add-member -membertype noteproperty vname $_.vname -passThru} | out-file ./tmp.txt

Sample output below. SCOM uses the FilePercentFragmentation number to warn on anything over 10%, what I'm wondering is how is the percentage calculated since it certainly isn't fragmented files divided by total files.

DefragRecommended : True

vname : I:\

AverageFileSize : 20277223990

AverageFragmentsPerFile : 1.11

ClusterSize : 4096

ExcessFolderFragments : 0

FilePercentFragmentation : 54

FragmentedFolders : 1

FreeSpace : 131237363712

FreeSpacePercent : 24

FreeSpacePercentFragmentation : 0

MFTPercentInUse : 10

MFTRecordCount : 65

PageFileSize : 0

TotalExcessFragments : 4

TotalFiles : 35

TotalFolders : 14

TotalFragmentedFiles : 2

TotalMFTFragments : 2

TotalMFTSize : 606208

TotalPageFileFragments : 0

TotalPercentFragmentation : 27

UsedSpace : 405626204160

VolumeName :

VolumeSize : 53686356787

powershell
Martin Hope
Chad Miller
Asked: 2009-06-25 07:25:58 +0800 CST
  • 6

Seeing a test server grow the tempdb log file to 8 GB used out of 12 GB allocated over the course of a couple hours while load testing. The tempdb data files have almost no file space usage. Running DBCC OPENTRAN in tempdb, there are no open transactions for more than a few seconds. I'm running SQL Server 2005 and read snapshot isolation is off.

How can I determine what is consuming tempdb log?

sql-server