While trying to troubleshoot the mirroring timeout issues which was in milliseconds, came across recommendation by a MS engineer to enable NetSH, below are instructions on how to enable it and capture logs, the logs can be supplied to Network vendor for further analysis.   Run following command to enable Netsh   Netsh trace start capture=yes scenario=netconnection maxsize=2000 filemode=circular overwrite=yes report=no persistent=yes tracefile=c:\%computername%.etl   Note: Please make sure you place this on a drive which […]

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 […]

While configuring Linked server to oracle database from SQL server, faced following error,   Error: “ORA-12504: TNS: listener was not given the SERVICE_NAME in CONNECT_DATA” (Microsoft SQL Server Error: 7303)     I did following validation checks to ensure things are in place: Tnsnames.ora – validated that SID is present in tnsnames.ora file which is generally located in C:\Oracle\product\11.2.0\client_1\network\admin\ folder Validate syntax of connection string, it should be in below format, ORA123 = (DESCRIPTION = […]

Sometimes there is need to take full dump for various kind of SQL Server issues and most of the time a DBA don’t know when issue going to occur hence becomes difficult to capture the dump, now to do same we need to have a standard approach, this post is compiled to work as procedure to take required dump file or automate it via trigger to ensure dump is taken even when no one is […]

  While doing search for SQL Server 2005 trace flags found few good links which greatly describe the info in detail, please use as per your requirement, most of them may be applicable to higher version of SQL Server as well.   Flags can be set for Session or Global (some are startup) levels though for later some can only be switched at startup using –T (you are suggested to avoid –t which turns on […]

  Recently while troubleshooting performance issue on a server, found that the CXPACKET waittype is high,   WaitType Wait_S Percentage AvgWait_S AvgRes_S AvgSig_S CXPACKET 1402132.06 56.82 0.0067 0.0063 0.0004   CXPACKET waits in the server are not an immediate sign of problem; they may indicate another problem, associated with one of the other high value wait types in the instance for e.g. Queries are executing with parallelism   Now when dealing with CXPACKET waittype do […]

As it is known fact that by default SQL Server 2008 and below does not support database files on network shared path \\<sharepath>\<databaseFileName>.<mdf /ldf>, this is done because of certain performance and stability factor (read more about this in links present in reference section of this article). But in case if there is requirement to do a temporary restore on a network share then the below tip will come handy.   Note: SQL Server 2008R2 […]

SQL Server proxies are used in cases where impersonation is required in complex and secured environments and more control is required while executing packages, jobs, PowerShell commands etc. below links and details are collected to give more info on this topic, it requires a good amount of reading and may take up to 2-3 hours to understand it completely, so be patient if you land on this page and go through all links and articles […]

We have some regular activities for which standard emails needs to be sent on regular basis, in order to reduce time in drafting email, there is built-in facility in Outlook to create and use email templates, so we can define the fixed text once and reuse it at regular intervals, below are the guidelines I found for learning this technique, please go through these links to understand how it works and can be utilized,   […]

NET USE command syntax:   net use [{devicename | *}] [\\computername\sharename[\volume] [{password | *}]] [/user:[domainname\]username] [/user:[dotteddomainname\]username] [/user:[[email protected]] [/home {devicename | *} [{password | *}]] [/persistent:{yes | no}] [/smartcard] [/savecred] [/delete] [/help] [/?]   Refer for more details: http://pcsupport.about.com/od/commandlinereference/p/net-use-command.htm   Examples of NET USE: Net Use Command Examples: net use * “\\server\my media” /persistent:no In this example, net use command is used to connect to the my media shared folder on a computer named server. The […]