Skip to main content

Posts

Showing posts from December, 2015

Activity Monitor fails- Microsoft SQL Server Management Studio

Error Details: Getting below error when trying to open process details or checking long queries in Activity Monitor window in SQL server R2 Enterprise Edition. The Activity Monitor is unable to execute queries against server [xxxx server]. Activity Monitor for this instance will be placed into a paused state. Use the context menu in the overview pane to resume the Activity Monitor. Other Information: Unable to find SQL Server process ID [PID] on server [xxxx server] (Microsoft.SqlServer.Management.ResourceMonitoring) Solution : This error exist because one of your service is not enabled on server.Name of Service is Performance Counter DLL Host. Just go to Services in control panel and find service Performance Counter DLL Host set it automatic and start the service. After doing this you need to close sql and reopen again. If still error not resolved then go to HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\PerfProc\Performance by in registry editor using regedt32 command.

Virus protection tips for your laptop of PC

1. Please do not open any Email attachments from unknown sources your own personal mail accounts such as Yahoo, Gmail, etc. 2. Kindly take backup all your important Data regularly on CD or DVD and scan external disk before using. 3. Please  do not click on any Links , sent from unknown sources, either via Emails or accessing your Facebook,twitter account.  These can be infected with virus. 4. Please do not Disable your Anti-Virus under any circumstances on your machine. 5. Update all Patches - Antivirus, Operating System , MS Office and windows patches update . 6. If you are unable to open any of your files then need to check virus infection and scan with antivirus. 7. If you use or share any External Drives such as  USB Hard Disks, need to SCAN them with the Antivirus software before using them.