Browsing articles from "December, 2012"
Dec
27
2012

MSDB database is growing due to sysmaintplan_logdetail table!

Today found an issue where MSDB database size was 4GB and the table which was utilizing more space is sysmaintplan_logdetail, now to fix it first identified the number of records present in table and the oldest dated, then deleted and truncated the maintenance plan history to clear those records, please find how all this is achieved using troubleshooting steps below,   Troubleshooting Steps: 1. First connect SQL Server via SSMS, then go to MSDB database […]

Dec
27
2012

Size of Transaction Log Increasing and cannot be truncated or Shrinked, log_reuse_wait_desc = replication

Today while troubleshooting log full issue, came across following scenario where two sql servers are in different domain and both are part of simple transactional replication where log file full was on subscriber, after investigation found that replication is working fine and no transaction are in undistributed state still log file is not shrinking, we tried changing recovery model to simple, etc but still issue didn’t get resolved. Finally we manually executed script to mark […]

Dec
27
2012

Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library [CLIENT: xx.xx.xx.xx]

Error:   Error: 17836, Severity: 20, State: 1 Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library [CLIENT: xx.xx.xx.xx]   Troubleshooting tips: Perform nslookup of the CLIENT IP Address that is listed in the error message [CLIENT: xx.xx.xx.xx] and find out what computer it is that is connecting. Then you need to check that machine and determine what […]

Dec
27
2012

Symantec Veritas Netbackup issue – Error (31073)

While setting up netbackup on one SQL Server 2008 R2, faced few errors on netbackup GUI client as, Error 1: Error in GUI interface, Error (31073) INF – Results of executing <C:\lclbin\tsv\bin\Trans_Trunc.bch>: <0> operations succeeded. <1> operations failed.   Troubleshooting Steps: With above error, getting no clue how to find the issue, so did following as per article http://www.symantec.com/connect/forums/mssql-2008-backup-status-2-29 , 1. Check the environment variables and add the path of veritas dbbackex.exe as E:\PROGRA~1\Veritas\NetBackup\bin\ (may […]

Dec
25
2012

SQL Agent service stopping due to a stop request from a user process or the os…

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

Dec
25
2012

Troubleshooting Insufficient Disk Space in tempdb

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

Dec
24
2012

Tips to optimize tempdb performance

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

Dec
24
2012

Get-WmiObject: The RPC server is unavailable (Exception from HRESULT: 0x80070721)

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

Dec
21
2012

Issue with Copy Paste in Windows – ctrl^C and ctrl^V not working

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

Dec
21
2012

Dedicated administrator connections not supported. (ObjectExplorer)

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

Pages:12»

Subscribe to this blog via Email

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

Join 24 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2012
M T W T F S S
« Nov   Jan »
 12
3456789
10111213141516
17181920212223
24252627282930
31  

View Post by Categories

%d bloggers like this: