Browsing articles in "Windows"
Nov
15
2017

Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations

While planning to configure always on availability group for first time on a multi subnet cluster found following use articles, it provides clear picture in terms of design and architecture, our requirement was to build SQL 2012 cluster on DC1 along with a reporting standalone SQL instance in same DC1, along with it, we want to have DR solution in DC2 where two standalone SQL instances are present on their respective server, to achieve this […]

Nov
9
2017

Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]

On a recently built SQL Server 2016 observed following errors every 5 mins,   Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: <local machine>] Error: 18456, Severity: 14, State: 5        As part of troubleshooting, tried following,   Created login DOMAIN\COMPUTER$ with public access as well as SA access but error continue to arrive Validated all SQL agent jobs, OS scheduler tasks, etc. but found nothing […]

Oct
3
2017

Windows Cluster Asymmetric Disks – In Always ON Clusters

Starting Windows 2012, Windows cluster supports asymmetric disks which is required for Cluster participating in Always ON technology hence is a useful concept to be aware of,   http://www.sqlserverfaq.net/2012/09/16/when-do-we-need-asymmetric-storage-with-alwayson-fci-and-availability-storage/   https://social.technet.microsoft.com/Forums/windows/en-US/493bf438-eb9d-405c-81c5-42aaa31eef8a/configure-asymmetric-storage-for-crosssite-windows-failover-cluster?forum=winserverClustering  

Sep
28
2017

Capture High CPU consuming process using Process Explorer

As a DBA we encounter situations when CPU is high on a DB server but DB is not consuming any CPU, we can see the processes consuming high CPU but don’t know how to identify that what process is doing causing issue and in cases where process is an encapsulated process like wscript.exe or any other system process we generally recommend server reboot but that generally washes out all logging; now as a DBA we […]

May
25
2017

Antivirus Exclusion List for SQL Server

After struggling a lot and working with vendor, identified list of exclusions for SQL Server related to Anti Virus Software (McAfee, Symantec, etc.), the details can be found in this link, last one is important as it impacts performance.   https://support.microsoft.com/en-us/help/309422/how-to-choose-antivirus-software-to-run-on-computers-that-are-running-sql-server   Directories and file-name extensions to exclude from virus scanning When you configure your antivirus software settings, make sure that you exclude the following files or directories (as applicable) from virus scanning. Doing this […]

Apr
10
2017

Error 17182 – TDSSNIClient initialization failed with error 0xd, status code 0x10

Issue: While trying to restart SQL Service, it failed and following error found in error logs,   yyyy-mm-dd hh:mm:ss.xx Server Error: 17182, Severity: 16, State: 1. yyyy-mm-dd hh:mm:ss.xx Server TDSSNIClient initialization failed with error 0xd, status code 0x10. Reason: Unable to retrieve registry settings from TCP/IP protocol’s ‘IPAll’ configuration key. The data is invalid.   yyyy-mm-dd hh:mm:ss.xx Server Error: 17182, Severity: 16, State: 1. yyyy-mm-dd hh:mm:ss.xx Server TDSSNIClient initialization failed with error 0xd, status code […]

Jul
25
2016

Windows Task Scheduler Error – transaction support within the specified resource manager is not started

While deleting a task in task manager, received following error reported by my team,   Error: “transaction support within the specified resource manager is not started or was shutdown due to an error”     We tried multiple options to modify job and delete but nothing worked, On further google search found that issue is similar to found on following forum,   http://answers.microsoft.com/en-us/windows/forum/windows_7-performance/transaction-support-within-the-specified-resource/fba64f34-4c16-4551-82d7-f22169be0d97?auth=1   Executed following command on server, fsutil resource setautoreset true c:\   […]

May
11
2016

Fix: Issue with Remote Desktop screen resolution while working from a high resolution system

Came across a unique issue on a friend’s laptop where he has high resolution screen but when trying to remote desktop any server then the remote server also inheriting the same resolution and text looks very small, MSTSC settings, desktop resolution settings, etc. everything is tried what possible but it didn’t fixed the issue. To resolve this, he found following solution to fix. Note: I am writing this post to keep a record of this […]

Jul
20
2015

SQL server setup failure – Updating permission setting for file E:\**** failed

While re-installing SQL server, got below error,       To fix this execute below commands with elevated access in command prompt so that permissions get applied to respective path,   Eg: takeown /F c:\Windows\system32\drivers /D y /R    In our scenario commands are provided below:   Here path is “F:” which is a parent folder.   takeown /F F: /D y /R   cacls F: /E /T /C /G “<<<user_AD_account_name>>>“:F

Jun
10
2015

Virtual Numa Overview – links

Came across following links relevant to Virtual NUMA, read for additional knowledge,     Vmware: https://pubs.vmware.com/vsphere-55/index.jsp?topic=%2Fcom.vmware.vsphere.resmgmt.doc%2FGUID-A80A6337-7B99-48C8-B024-EE47E2366C1B.html     Hyper-v https://technet.microsoft.com/en-ca/library/dn282282.aspx

Pages:1234»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 34 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2017
M T W T F S S
« Nov    
 123
45678910
11121314151617
18192021222324
25262728293031

View Post by Categories

%d bloggers like this: