On SQL Server 2008 R2 RTM edition faced issue that SQL Agent is not coming up, following errors noticed when services started via SSCM (SQL Server Config Manager) console and via SSMS (SQL Server Mgmt Studio), SSCM: SSMS:   In Agent Error logs, following was found, —— 2011-11-29 13:28:30 – ? [310] 4 processor(s) and 8192 MB RAM detected 2011-11-29 13:28:30 – ? [339] Local computer is xxxxx running Windows NT 6.1 (7601) Service Pack […]

Text Reference: http://dba.stackexchange.com/questions/19870/how-to-identify-which-query-is-filling-up-the-tempdb-transaction-log Some tips for minimizing tempdb utilization 1. Use fewer #temp tables and @table variables 2. Minimize concurrent index maintenance, and avoid the SORT_IN_TEMPDB option if it isn’t needed 3. Avoid unnecessary cursors; avoid static cursors if you think this may be a bottleneck, since static cursors use work tables in tempdb – though this is the type of cursor I always recommend if tempdb isn’t a bottleneck 4. Try to avoid spools […]

In order to optimize tempdb performance pay attention to physical disk configuration, file configuration, as well as some settings within the database. Physical disk configuration tempdb should reside on its own dedicated physical disks. This allows it to split I/O transactions from the remainder of volumes on the SQL Server. To move tempdb to a new disk drive, use ALTER DATABASE. It is the key T-SQL command to perform this operation. Microsoft offers a good […]

While I tried to use PowerShell to find disk space of a remote server using WMI query, Get-WmiObject -computer <myservername> win32_volume …faced following error/s, ——- Error 1: Get-WmiObject : The RPC server is unavailable Error 2: Get-WmiObject : A security package specific error occurred. (Exception from HRESULT: 0x80070721) —— After some Googling and search found some useful tips to troubleshoot the issue, please find below the consolidated troubleshooting steps, 1) Check that DCOM is enabled […]

If you are working with remote computer and see that ctrl^C and ctrl^V (i.e. copy paste) is not working then culprit can be clipboard or remoteclip or ASC, please find below solution to fix these issues, How to Clear Clipboard in Windows How to Clear Clipboard on Windows XP: Click the “Start” button and enter “Clipbrd” into the “Run” field. A record of recent clipboard content will appear. Select “Edit” from the top of the […]

When you try to connect to SQL Server using SSMS by giving connection string as ADMIN:<Servername>\<Instancename> you get following error, i.e. Dedicated administrator connections not supported. (ObjectExplorer)   Now you have already verified that your DAC is enabled in SQL Server Surface Area Configuration, it is already listening on some <port no> (you can verify from SQL error logs that which port it is using) etc. but still why the error?   The answer is, […]

Today while investigation intermittent SQL server unavailability, noticed several buffer pool memory dumps in error logs which are causing SQL server to stop responding randomly,   Error Noticed: Error 1: From Windows Event logs A significant part of sql server process memory has been paged out. This may result in a performance degradation. Duration: 327 seconds. Working set (KB): 8058460, committed (KB): 21122984, memory utilization: 38%%. —— Error 2: From Windows Event logs IO Completion […]

Today while writing script I need to echo output to an html file using batch file, so requirement is, I need to insert a break and then text in center of email, text as “—————–Database Report———————-“, now to do this you need to use carrot, see below, My batch script looks like, SET currentdirectory=%CD% echo ^<BR^> > “%CD%\output.htm” echo ^<center^>^———–Database Report————–^</center^> >> “%CD%\output.htm”     Hope it helps!   Reference: http://forums.devshed.com/other-programming-languages-139/echo-html-in-a-batch-file-339368.html

There are many applications which use these system dll for e.g. BMC client, etc., if you see these dll’s missing error then follow below tip, 1. Download both dll’s from this link: http://www.addictivetips.com/windows-tips/fix-msvcp71-dll-and-msvcr71-dll-missing-error-in-windows-7/ or you can use someone else system and copy these dll’s as well (if available) Note: Although it is not recommended method to download dll from third party website to avoid any damage to system, but personally I have used above link […]

I was eagerly searching for a solution to call a VBScript through PowerShell script, after going through several articles and collecting information in bits and pieces from various sources written a very small and useful code, you can use it at your wish, My requirement: Call vbscript along with passing two arguments to it, one is server name and other one is a folder name.   Command: 1. Declare $args to collect arguments (in this […]