Clear mssql cache
If you for example need to test a query against two SQL servers hardware, its a good idea to clear the cache first.This query can do this:
Kenneth Qvistgaard Dalbjerg, IT Konsulent i århus
If you for example need to test a query against two SQL servers hardware, its a good idea to clear the cache first.This query can do this:
When going to Settings -> Accounts -> Access work or school, og push the “connect” buttom. I could just see that the popup, asking for my mail address, just popup, but then disapear again...
Today i have this warning in my Veeam Backup and Replication backup job log, for an SQL server:Failed to finalize guest processing. Details: Failed to call RPC function ‘Vss.TruncateSqlLogs’: Error code: 0x80004005. Failed to...
If you have vmware ESXi or Microsoft Hyper-v, you can expand a disk, from the hypervisor console, very simple. But afterwards the partition the servers is not expand.It is always a good idea to...
If you need to get all certificates, from a list of remote computers, you can use this script:
If you need to found out whitch groups (mailling groups) a contact is member of in Microsoft 365, then you case use these powershell commands: Replace [email protected] with yours mail address.
Here is a list of SNMP OID list for iLO4, to used in yours monitoring software like Atera. Fans:.1.3.6.1.4.1.232.6.2.6.7.1.2.0 (Fan Index).1.3.6.1.4.1.232.6.2.6.7.1.3.0 (Fan Locale (1=other, 2=unknown, 3=system, 4=systemBoard, 5=ioBoard, 6=cpu, 7=memory, 8=storage, 9=removable media, 10=power...
To sign a certificate with a specific template with Windows Certificate Authority
You can use this command to see the status of the Raid Controller and Raidset.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 |
Generating detailed summary of the adapter, it may take a while to complete. Controller = 0 Status = Success Description = None Product Name = Intel(R) RAID Controller RS3DC080 Serial Number = SK94678290 SAS Address = 500605b00f7ef7e0 PCI Address = 00:b5:00:00 System Time = 03/18/2022 15:44:57 Mfg. Date = 11/24/19 Controller Time = 03/18/2022 15:44:29 FW Package Build = 24.21.0-0126 BIOS Version = 6.36.00.3_4.19.08.00_0x06180203 FW Version = 4.680.00-8519 Driver Name = lsi-mr3 Driver Version = 7.702.13.00 Current Personality = RAID-Mode Vendor Id = 0x1000 Device Id = 0x5D SubVendor Id = 0x8086 SubDevice Id = 0x9360 Host Interface = PCI-E Device Interface = SATA-3G Bus Number = 181 Device Number = 0 Function Number = 0 Drive Groups = 1 TOPOLOGY : ======== ----------------------------------------------------------------------------- DG Arr Row EID:Slot DID Type State BT Size PDC PI SED DS3 FSpace TR ----------------------------------------------------------------------------- 0 - - - - RAID5 Optl N 5.451 TB dflt N N dflt N N 0 0 - - - RAID5 Optl N 5.451 TB dflt N N dflt N N 0 0 0 252:4 8 DRIVE Onln N 930.390 GB dflt N N dflt - N 0 0 1 252:5 9 DRIVE Onln N 930.390 GB dflt N N dflt - N 0 0 2 252:6 10 DRIVE Onln N 930.390 GB dflt N N dflt - N 0 0 3 252:7 11 DRIVE Onln N 930.390 GB dflt N N dflt - N 0 0 4 252:0 15 DRIVE Onln N 930.390 GB dflt N N dflt - N 0 0 5 252:1 12 DRIVE Onln N 930.390 GB dflt N N dflt - N 0 0 6 252:2 13 DRIVE Onln N 930.390 GB dflt N N dflt - N ----------------------------------------------------------------------------- DG=Disk Group Index|Arr=Array Index|Row=Row Index|EID=Enclosure Device ID DID=Device ID|Type=Drive Type|Onln=Online|Rbld=Rebuild|Dgrd=Degraded Pdgd=Partially degraded|Offln=Offline|BT=Background Task Active PDC=PD Cache|PI=Protection Info|SED=Self Encrypting Drive|Frgn=Foreign DS3=Dimmer Switch 3|dflt=Default|Msng=Missing|FSpace=Free Space Present TR=Transport Ready Virtual Drives = 1 VD LIST : ======= ------------------------------------------------------------- DG/VD TYPE State Access Consist Cache Cac sCC Size Name ------------------------------------------------------------- 0/0 RAID5 Optl RW Yes RWBD - ON 5.451 TB ------------------------------------------------------------- EID=Enclosure Device ID| VD=Virtual Drive| DG=Drive Group|Rec=Recovery Cac=CacheCade|OfLn=OffLine|Pdgd=Partially Degraded|Dgrd=Degraded Optl=Optimal|RO=Read Only|RW=Read Write|HD=Hidden|TRANS=TransportReady|B=Blocked| Consist=Consistent|R=Read Ahead Always|NR=No Read Ahead|WB=WriteBack| AWB=Always WriteBack|WT=WriteThrough|C=Cached IO|D=Direct IO|sCC=Scheduled Check Consistency Physical Drives = 8 PD LIST : ======= ------------------------------------------------------------------------------------- EID:Slt DID State DG Size Intf Med SED PI SeSz Model Sp Type ------------------------------------------------------------------------------------- 252:0 15 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 870 QVO 1TB U - 252:1 12 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 870 QVO 1TB U - 252:2 13 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 870 QVO 1TB U - 252:3 14 UGood - 930.390 GB SATA SSD N N 512B Samsung SSD 870 QVO 1TB U - 252:4 8 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 860 EVO 1TB U - 252:5 9 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 860 EVO 1TB U - 252:6 10 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 860 EVO 1TB U - 252:7 11 Onln 0 930.390 GB SATA SSD N N 512B Samsung SSD 860 EVO 1TB U - ------------------------------------------------------------------------------------- EID=Enclosure Device ID|Slt=Slot No.|DID=Device ID|DG=DriveGroup DHS=Dedicated Hot Spare|UGood=Unconfigured Good|GHS=Global Hotspare UBad=Unconfigured Bad|Onln=Online|Offln=Offline|Intf=Interface Med=Media Type|SED=Self Encryptive Drive|PI=Protection Info SeSz=Sector Size|Sp=Spun|U=Up|D=Down|T=Transition|F=Foreign UGUnsp=Unsupported|UGShld=UnConfigured shielded|HSPShld=Hotspare shielded CFShld=Configured shielded|Cpybck=CopyBack|CBShld=Copyback Shielded Cachevault_Info : =============== --------------------------------------------------------- Model State Temp Mode MfgDate Next Learn --------------------------------------------------------- CVPM02 Optimal 23C - 2020/04/09 2022/03/31 00:41:59 --------------------------------------------------------- |
Here you can see under PD List, that drive 252:3 14 stand as UGood. Thats the new disk...
If you ever need to see the status of a running jobs, this TSQL can be very helpfull
If you wan to know the sync status of a always On availability group database replication, this command can be used:
Sidste kommentar