edgoad

Search This Blog

Installing a new ESXi server

on November 08, 2017

Get link
Facebook
X
Pinterest
Email
Other Apps

Get link
Facebook
X
Pinterest
Email
Other Apps

Comments

Using SCOM to monitor SQL Error Logs

Our SQL DBA reported that occasionally he will see errors in the SQL Error Logs similar to: SQL Server has encountered 45 occurrence(s) of IO requests taking longer than 15 seconds to complete on file [T:MSSQLDatatempdev6_Data.NDF] in database [tempdb] (2). The OS file handle is 0x000005B4. The offset of the latest long IO is: 0x0000000c7b2000 Monitoring for this alert at first sounded simple, but as I dug into it I realized it could be much more difficult than I expected. First off, this error is reported in the SQL Error Logs and only in the SQL Error Logs, so we cant simply use the NT Event log to alert us. Secondly, depending on how you install SQL, these error logs could be anywhere on the system. And lastly, this is needed to be monitored on SQL 2000 and SQL 2005 systems, so xp_ReadErrorLog won’t work for us. So the breakdown seems fairly simple: find out where the logs are, use the text log monitor, and search for the string. 1. Find out where the SQL Error logs are store...

System Configuration and Management -- Build a simple RPM that packages a single file

This is an interesting objective – something that I have never had to do before. After looking around at various tutorials and such, the wording of the objective is even more confusing – RPM packages are designed to install programs, not just copy a file. For example, there is a great how-to for creating RPM packages at http://fedoraproject.org/wiki/PackageMaintainers/CreatingPackageHowTo . A few days looking and I actually came upon a need to create a package – I want to have a silent install of Linux in our datacenter that copies custom scripts to the systems. The best way to handle this would of course be to build an RPM package that included just the one script. A little Googling and bingo! http://lincgeek.org/blog/?p=303 has just the information I needed on how to package a single file and direct it to install into a specific location. STEP 1 : Install the necessary packages Each site you go to says something different, but it appears that the rpmdevtools contain...

Sharing folders - Hidden shares

Powered by Blogger

Installing a new ESXi server

Comments

Post a Comment