SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,951 questions
5 answers
One of the answers was accepted by the question author.
MSDN Forum:SQL server performace issue with different storage
Hi Team, We are running same queries on two different SQL servers with version SQL server 2014 whereas we used different storage HP3PAR and NETAPP for both the servers but while execution of the queries for NETAPP storage we are getting wait type…
asked 2020-09-21T07:45:05.797+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(57.599999999999994, 0%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EMA%3C/text%3E%3C/svg%3E)
Mohan Agarwal
21
Reputation points
answered 2020-09-24T13:19:05.367+00:00
Mohan Agarwal
21
Reputation points
0 answers
some virtual disk's goes Retired automatically with out any issue in S2D
Im not sure certain disk's goes Retired im not sure, what is happening this are virtual disk, when I restart the server the same disk will not be in the Pool.. I have to issue the below command $disk = get-physicaldisk | ? CanPool…
asked 2020-09-21T11:53:43.447+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(252.8, 19%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAB%3C/text%3E%3C/svg%3E)
Abdul Baba Syed
21
Reputation points
commented 2020-09-22T08:25:37.403+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(259.20000000000005, 8%, 35%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daniel Zhou (Shanghai Wicresoft Co,.Ltd.)
256
Reputation points
2 answers
Server 2019: Files not inheriting permissions after move
By design, when a user moves a file within a volume, the NTFS permissions (ACL) moves with the file. This is different from a copy operation where the destination file will inherit permissions that are set by the target folder. In my case, the volume…
asked 2020-09-21T12:09:04.26+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(60.8, 89%, 15%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
cKoppen
6
Reputation points
commented 2020-09-21T13:38:17.133+00:00
Leon Laude
85,686
Reputation points
1 answer
DFS Shares going offline after user's device was converted over to folder redirection
Hello, Having a hard time trying to figure out the fix on this issue that's been going. We have two file servers (we will be consolidating it down to one, but that's a project for another time). Both of these file servers live in Azure One file…
Windows
Windows
A family of Microsoft operating systems that run across personal computers, tablets, laptops, phones, internet of things devices, self-contained mixed reality headsets, large collaboration screens, and other devices.
4,882 questions
Windows Server Storage
Windows Server Storage
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.Storage: The hardware and software system used to retain data for subsequent retrieval.
638 questions
asked 2020-09-15T12:53:48.49+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(236.8, 11%, 32%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EC%3C/text%3E%3C/svg%3E)
cz57avenger
1
Reputation point
commented 2020-09-21T07:44:13.833+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 62%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EDZ%3C/text%3E%3C/svg%3E)
Daisy Zhou
19,586
Reputation points Microsoft Vendor
2 answers
Is it possible to script ISCSI MCS connection setup?
Hello - When I set up servers, I typically script as much of the setup as possible to make them as consistent as possible. I have powershell that I use to set up ISCSI MPIO that works for most scenarios that require multiple connections. I recently came…
asked 2020-09-12T18:14:47.33+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(150.4, 28.999999999999996%, 24%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETR%3C/text%3E%3C/svg%3E)
Tim Reid
1
Reputation point
answered 2020-09-21T00:39:21.087+00:00
Alex Bykovskyi
1,821
Reputation points
2 answers
Storage Space direct cluster colum Count confusion
I have 3 nodes, joined to cluster and created storage space and a volume.. Each node has 3 HDD disks, each 1 TB and created a volumes look at the image, why 1gb size is taken as 3.94 GB and column count is 4, i have only 3 disk per node, how…
asked 2020-09-16T05:17:24.037+00:00
Abdul Baba Syed
21
Reputation points
answered 2020-09-18T13:24:43.97+00:00
Abdul Baba Syed
21
Reputation points
1 answer
ReFS Integrity Streams and Data Deduplication
We recently had some corruption on one of our file servers and we thought it should have healed itself, though it didn't. We found something interesting that we wanted to get confirmation on. We had a 12 bay server populated with 10 SAS HDD's and 2 SAS…
asked 2020-09-03T18:56:51.633+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 8%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EB%3C/text%3E%3C/svg%3E)
Bernie
21
Reputation points
commented 2020-09-17T07:09:28.757+00:00
Daniel Zhou (Shanghai Wicresoft Co,.Ltd.)
256
Reputation points
0 answers
NFS + Storage Spaces?
Hi all, how are you? I have a very weird issue here, in one hand, I have a physical disk HDD with 500GB NTFS, with a NFS Shared folder with anonymous connection and works well (for create files, modify, etc). In the other hand, I have a Storage Pool…
asked 2020-09-15T14:02:20.083+00:00
Masterop512
21
Reputation points
commented 2020-09-16T08:17:02.867+00:00
Daniel Zhou (Shanghai Wicresoft Co,.Ltd.)
256
Reputation points
1 answer
Mapped Network Drive Randomly Disconnects - Have to switch between Netbios name and FQDN to be able to connect to server
I have a user who has mapped drives to a share on a server. For some reason every couple of days her drives disconnect. Logging off and back on and restarting do not solve the connection issue. In fact we have to disconnect and re-map the drives to get…
asked 2020-09-10T18:21:14.247+00:00
Courtney Whitley
16
Reputation points Microsoft Employee
commented 2020-09-16T07:35:24.717+00:00
Gloria Gu
3,891
Reputation points
1 answer
Disabling Bitlocker on Storage Replica Clustered disk
Hi, I have a Server 2016 stretched cluster running Storage Replica to replicate a volume from site A to site B. The replicated volume has Bitlocker enabled. We've recently implemented encryption at the SAN layer, so now want to remove Bitlocker.…
asked 2020-09-11T13:21:46.427+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(99.2, 26%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ETB%3C/text%3E%3C/svg%3E)
Tim Boothby
1
Reputation point
commented 2020-09-16T03:39:10.783+00:00
Xiaowei He
9,876
Reputation points
2 answers
Windows 2016 Deduplication
We run a files server around 3TB on Windows 2016. Free space is ending and there are no additional disk slots. Our IT budget is tight and purchasing new servers is not an option. I have red, that Windows has deduplication feature. Is it worth installing?…
asked 2020-09-05T08:17:23.373+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(220.8, 32%, 31%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERS%3C/text%3E%3C/svg%3E)
Rapech Sinkg
1
Reputation point
commented 2020-09-16T03:37:32.633+00:00
Xiaowei He
9,876
Reputation points
1 answer
Windows 2019 files on disk not showing up
I just coped about 1TB of data from a 2016 Filer Server to a 2019 file Server - 1 large folder and its contents On source server Size 898 GB 545k files 135k folders On dest server Size 9.25GB 9k files 5k folders On Dest Server Volume shows…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(256, 1%, 34%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
2 answers
Does Storage Replica require VSS?
The "Server-to-server storage replication with Storage Replica" page says: "We strongly recommend enabling Volume Shadow Copies and periodically taking snapshots with VSSADMIN or your other tools of choice. This will guarantee applications…
asked 2020-09-09T14:40:44.147+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(201.6, 57.99999999999999%, 29%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
Rich B
6
Reputation points
commented 2020-09-15T05:33:56.35+00:00
Daniel Zhou (Shanghai Wicresoft Co,.Ltd.)
256
Reputation points
2 answers
One of the answers was accepted by the question author.
Mirror Accelerated Parity with DAS in Cluster Storage
I couldn't find a clear answer online on if a mirror accelerated parity was supported when using a 2 host fail over cluster with shared DAS storage. This is not a S2D setup.
2 answers
Can Storage Replica use WinRM over https?
On the Storage Replica documentation it lists one of the Pre-requisites as "Appropriate firewall and router rules to allow ICMP, SMB (port 445, plus 5445 for SMB Direct) and WS-MAN (port 5985) bi-directional traffic between all nodes." …
4 answers
workstation service is broken
can someone help me fix it? Hello?
asked 2020-09-04T02:36:15.51+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(214.4, 36%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECY%3C/text%3E%3C/svg%3E)
Christopher Yorkshire
1
Reputation point
answered 2020-09-09T09:16:05.193+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(281.6, 28.999999999999996%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EVW%3C/text%3E%3C/svg%3E)
Vicky Wang
2,646
Reputation points
4 answers
How to find ISCSI target LUN - by cmd or powershell or...by ...whatever?
Hi, I wonder what is the way to find out Iscsi Target's LUN? In a command like Iscsicli there are options to include this parameter, but... how to get it? GUI or cmd/powershell? Anyone? Reference: …
asked 2020-08-27T15:43:06.643+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(284.8, 52%, 37%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EI%3C/text%3E%3C/svg%3E)
InfoTechdude
156
Reputation points
commented 2020-09-08T12:44:03.46+00:00
InfoTechdude
156
Reputation points
2 answers
After a random period of time of many days or even weeks, RD users begin to get “File Cannot be Opened” errors via mapped drives on SMB Shares.
Setup as follows: Windows 2019 RDS with manually created persistent drive mappings on Windows 2016 File Server. ERP software with flat file databases is stored on the file server and runs through these mappings, so there is a lot of SMB network traffic…
asked 2020-08-24T12:11:28.48+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(208, 40%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ES%3C/text%3E%3C/svg%3E)
SNP
1
Reputation point
commented 2020-09-08T07:57:04.69+00:00
Karlie Weng
15,281
Reputation points Microsoft Vendor
1 answer
One of the answers was accepted by the question author.
Failover Cluster/Hyper-V Machines/Cluster Storage Volume/Status_Connection_Disconnected
2 Node Failover Cluster with S2D, Hyper-V Machines' vhdx active on Cluster Shared Volume. Issue: CSV "Storage Name" consistently enters pause state due to Status_Connection_Disconnected. RHSCall::DeadlockMonitor: Call ISALIVE timed out…
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(80, 74%, 17%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
4 answers
Storage Spaces, BitLocker not accepting recovery key
As a bit of context, I have a server running Server 2019 with a storage pool using local hard disks, been running fine for a year or so. Previously replaced disks without any issues. At the end of last week, I needed to upgrade a disk, so I added the…
asked 2020-08-27T10:16:45.297+00:00
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(22.400000000000002, 65%, 12%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERP%3C/text%3E%3C/svg%3E)
Richard Pope
1
Reputation point
answered 2020-08-28T18:19:51.897+00:00
Richard Pope
1
Reputation point