I need to parse temperature data from esxi servers, to db for visualization the server room stats. I have 3 servers running esxi 6.5      IBM System x3250 M3     IBM IBM System x3550 M4 Server     Dell PowerEdge R630 I tried snmp walk but i cant find temperature data. I would be great to have data at least from one server
121042
For ESXi5.1 (VMWare vSphere) images, I can see temperature data on the vSphere user interface (under Monitor / Hardware Status). I tried scouring the available snmp data using snmpwalk, but can't find the data anywhere in there.  Maybe I'm missing something. Does anybody know the right MIB for temperature data?  Otherwise, how can that data be accessed?  By the way, this is a machine installed from an image .  EDIT: The hardware is ProLiant DL360 G7.  I don't wish to monitor the server, but rather to plot the available temperature meters.
21046
I run distributed computing projects, which typically want to use 100% of the CPU.  How do I limit the CPU usage in terms of temperature instead of percent usage?  Also, what is the maximum safe temperature to keep an Intel i5 running 24/7?  (With no CPU limit FahCore_a4 causes this machine to run at 82 degrees Celsius.)
75443
I have a freebsd box, which serves as a router from LAN to the outside world. It has several Internet providers, OpenVPN servers and clients, NAT and so on.  I would like to have complete statistics on when, who, to whom, via which provider, via which protocol, and how many bytes have been sent.   I agree that the minimal time scale will be an hour, i.e. no need for millisecond precision.  I tried vnstat2, ntopng and some other programs, but they don't seemed to have what I need or it is not obvious.   I don't understand, why this feature is not easily available. But I am not good in freebsd, so please, give me some clues.
75039
I'm now going on vacation, and I won't be having Internet connection there. I was thinking it would be a good time to browse through the Stack Overflow data dump. However, it's all in XML and I'd have to write a client to make it readable. Is there any existing client?
86094
My current employer has given me the opportunity to design my own GIS workstation. The problem is I have no idea what is important when it comes to hardware! I have been given a datasheet from Fujitsu which includes the latest CELSIUS M720 series workstations but the configuration includes about 30 different processors, graphics cards, and hard drives.  I will be working a lot with the ESRI desktop suite (spatial analyst and 3D analyst) and doing a fair amount of raster processing (DEMs, visibility analysis, etc.), but I also use the GDAL library, SAGA-GIS, Quantum GIS and others.  Does ArcGIS 10 actually use multiple cores?  I have the choice from 4 cores with 8 threads up to 8 cores with 8 threads - 16 threads?  Is SSD SATA III better than HDD SATA III?  The Celsius R920 supports up to 512 GB RAM. But what do I need?  It will probably be the last time I get a new workstation for the next 5 years, so I am curious what others have ordered or feel will be necessary for the coming years. Obviously the cloud isn't taking over as quick as they say!
122113
I have 4 hard disk drives that have temperatures which go beyond the recommended 50 degrees (Celsius). (I have several Samsung Spinpoint F3 which are 1Tb each and they do have good temps, between 32 and 35 degrees. That's normal for me. But in this case, 50+ is not normal.)  I have already read the question and answer provided , but none of the solutions  helped. What tools can I use or what terminal commands should I execute to lower the temperature of these drives?  And on a similar note, if I were to use a method similar to , how would I know which hard drive I am reading?   Where can I check to see which HDD is related to, for example, /sys/class/scsi_host/host0/link_power_management_policy ?  I have already tested powertop, hddtemp, disks and others to check and try to lower the temp with no luck.
17784
Not sure if this is actually desired, but  is currently showing me (a SE non-dev)  results, including all queries that are being run against the DB (not talking about data-explorer queries of course, talking about site rendering queries).    New feature of  or a deployment whoops?  Edit:  I didn't realize that data was .  With that in mind, this probably isn't a security problem after all, and is in fact more likely .
115988
Our server: HP Proliant ml350p g8 has a single Xeon e5-2609 1.4Ghz processor. Our manager wanted to update it a little, so we looked at 2x E5-2609V2 processors...we ran it past HP Enterprise chat who said it was compatible.  We now have the new CPUs and when we installed them our Health LED was solid red and server wouldn't POST. We've tried each of the new CPUs individually and together but same result. We thought perhaps it was the BIOS (it was dated 2012!).  Our server is out of warranty so we initially wasn't allowed to download the latest BIOS, but our manager persuaded HP to give us the latest BIOS version (2015), which we have installed. Trying the CPUs again has the same result...server still won't POST  If anyone could please shed some light on what we have missed that would be great.  (We are in the process of getting quotes for HP Maintenance Contract - since we are past 30 days expired on our Warranty, so we can't get a care pack)
6002
We currently have several shared SQL Server servers and instances in our organization. They are going with a different architecture where business units will get their own SQL Server instances. We have SQL Server 2008R2.  In the past, databases were put on servers in a more or less random fashion -- business use and disk space were the main drivers.  I've been tasked with coming up with a plan for allocating our 50+ databases across 3 servers (one instance per server). My criteria for divvying them up is as follows:   Business critical db's should be spread across the servers. i.e. avoid lumping a bunch of business critical db's all one server.   For the remainder of the non-mission critical db's, consider: a. Disk space usage b. I/O usage -- memory, CPU, etc.     1 and 2a are easy for me to figure out. I know how to get data file sizes.   My question is with that last bit - 2b. I do not know how relevant this is, what specific stats to look at, or how to get them.   Frankly, I'm not 100% sure how to phrase this question! I think I basically want to know is, "How 'busy' is this db -- however you define 'busy'?" Or maybe, "How does this db impact the performance of the server?"  I mean, disk space is important -- but it could (in theory) have a ton of rows or binary objects in there that are not written very often, so it has little impact on the performance of the server. I think I would want to know how much impact a db within a date range.  Is there a way to get these kind of general stats? I'm not looking for expensive queries, detailed user stats, or query optimization here. I'm aware of the SSMS reports, but they seem to be more real-time. The end goal is to divide up our current databases into evenly balanced buckets, and I would think performance is one way to do that.  Thoughts? Wisdom? Any other ideas on how to divvy up the db's?  Thanks! Tom
87176
I have 50 servers. I manage them from a central management server on SQL Server 2014 Enterprise Edition. I don't use repository.  I could open a query and get result for each one at the same time. But I want to do it in an automated way, like a job, to collect data from each server and store/handle it locally.  Is this possible and if so, how?
81730
Everest Ultimate is suddenly telling me that the CPU temperature (and core temps) for my E6850 Core 2 Duo is 72 degrees Celsius. When I stress-test the machine, the temp goes up to 91 degrees and the CPU actually throttles. System remains stable though.  For over a year now, my CPU has run very cool (40's) with a large commercial copper heatsink/fan that I bought separately.   To top it off, I removed the cover of the box and felt the cpu heatsink and it wasn't even warm.   Is there such a thing as a CPU temp sensor showing the wrong readings?  Any tips would help.  UPDATE #1  Temp is also just as high in BIOS. So that leads me to believe it's a CPU seating issue (even though I used thermal paste to seat it two years ago when I built the machine)  UPDATE #2 Well. I removed the heatsink and cleaned off the original thermal paste (which was somewhat crusty). I polished the surface, re-applied some new paste, and reseated the heat sink. After powering it up, there was no noticeable change in the temp - ideling at 74. Ran the stress test and it went up to 94 degrees before being 100% throttled. I let it sit at 94 degrees for 20 minutes straight and the computer didn't even flinch. I then immediately shut it off and opened the case and felt around. The heatsink was completely cold to the touch. Even the copper rods were cold. The area near contact with the CPU was slightly warm but not hot to touch.  Then I ran REALTEMP, which is supposedly more accurate and it told me the CPU was at 104 degrees. (LOL)  At this point, I'm thinking no doubt the cpu's sensor is wrong. Sidenote: the BIOS has the latest version so no option to flash there. Reverting hasn't been known to help from what I've read.  What angers me is the false temps force the CPU to artificially throttle from 3GHz down to 2GHz and my CPU fan is cranking at full force all the time.  Should I call intel and tell them to send me another E6850?   SOLUTION UPDATE  I switched the processor out with another one and got the same obscene temperatures with the new processor followed by a heatsink that was cool to touch. My suspicion in the heatsink was suddenly renewed. I swapped it out with the stock heatsink/fan and lo and behold the temperatures returned to the normal 35C-50C. Even though the thermal paste was visibly flattened out every time I removed it, it looks like the heatsink was still not pressing hard enough on the CPU to effectively conduct the heat. The heatsink is a Masscool 8Wa741, which screws into a standard position on a mount on the back of the MOBO. Only thing I can surmise after 2 years of use was that, over time, the heatsink pressure on the CPU gave way until the heat began to be ineffectively conducted.   Lessons learned:     Intel CPU's can run SUPER HOT (upwards of 95C) and still be stable.  Heatsink's need to be VERY firmly pressed against the CPU to conduct heat.
101999
Hi guys I have question about how two different Hard disk setups can possibly affect performance of my database.   I have two Options.  Option 1:  One Physical Harddisk and then Multiple Virtual hard drives for SQL Server's Database files (.mdf , .ndf),Log files, TempDB, Backups etc   Option 2:  One Physical Harddisk and then One huge Virtual hard drive for SQL Server's Database files (.mdf , .ndf),Log files, TempDB, Backups etc     To my knowledge, If these were all physical hard drives, having multiple drives for all these files (tempDB, Log file, backups, database files), would definitely benefit from  parallel processing.  But is there any drawbacks of having one massive Virtual Hard drive vs multiple Virtual Hard drives as in reality, when Sql Server is reading or writing , it will be all done from one Physical Hard disk?   Is one method preferred over other? Any suggestions or pointers in the right direction is much appreciated. Thanks
115433
I have a cheap wireless pool thermometer (AcuRite 617 ) and I'd like to intercept the temperature data at the receiver and use it with a computerized data-logging system.  Conveniently, inside the receiver is a small break-out board that is connected to the antenna and has digital "V", "G", "D", and "SH" pins:    Here is a segment of captured data from the "D" pin during a transmission (these happen once per minute). Before this segment, there is what appears to be much-higher-rate data, but I believe that might be noise -- this is the beginning of the 1.36kHz / 680Hz data.    I've googled a bit and can't find an encoding that looks quite like this, but if I were to guess what's going on, here's what I'm thinking:   the initial 4 cycles of 680 Hz are to synchronize the clocks but contain no data the 13 cycles of 1.36 kHz (2x the initial rate) that follow appear to have one of two forms: they either drop low before the midpoint of the cycle or after it -- i'd assume one form is a logical one and the other is a zero. after that, there appears to be a weird gap, but if you discount the part of the low that is part of the preceding "1", then the remaining gap is 735 µs, which is a (phase-correct!) continuation of the 680 Hz preamble.   Am I looking at this correctly? Is there a name for this encoding?  Some further notes on the break-out board:   the board is marked "RF211" and looks remarkably consistent with the MICRF211 "general purpose, 3V QwikRadio Receiver that operates at 433.92MHz" the MICRF211 data sheet has the following figure (with very little explanation), which looks tantalizingly like what i'm seeing except for the double-data-rate square wave as compared to my capture:    2016-02-14 Update: I've revisited this project and appear to be getting a clean 64-bit stream between a 4-cycle preamble and a 1-cycle "postamble", after which the display board shuts down the RF module by pulling ^SH low (top line):    According to Micrel's "33/66% PWM" scheme (which appears nowhere else on Google), that's  -_-_-_-_0000011110011000110000000000000000000000100011101000010010101010-_   So now I have to start manipulating the temperature to decode the bits. Here ("x") are the bits that seem to change without any apparent change in the display:  0000011110011000110000000000000000000000100011101000010010101010 ------------------------------------------------x----xxxx----xxx   I assume these are either least-significant bits or battery-level (which is only shown as "Low" when it drops significantly).  2016-02-15 Update: I'm taking the show on the road to give the new "Reverse Engineering" stackexchange a crack at determining meaning:
100035
When configuring new SQL Servers on VMs, it is a good idea to have the Database, TempDB, logs, and backups on separate logical drives, even if the underlying storage is the same? I know that this is a good practice on physical servers; the separation actually helps us to reduce the pains caused by concurrent I/O.   I am trying to understand if having 3 drives instead of 5 would make sense. Can someone please provide their views/suggestions for this idea?
16686
prints out a lot of very detailed protocol statistics like number of TCP reset messages received or number of ICMP "echo request" messages sent or number of packets dropped because of a missing route.  When in Linux netstat is considered deprecated at nowadays, then is there an alternative?  Statistics provided by ss -s are superficial compared to the ones provided by netstat.
70563
Three server A,B &amp; C. How to ssh connect from A to C via intermediate server B, if A to B &amp; C to B are password less(key)? I encountered this in an interview. Anyone knows how?
79475
I have a fairly busy database server running SQL Server 2008 R2 that has the following setup:   SATA RAID 1 (2 Drives)  - OS / Programs SAS  RAID 10 (4 Drives) - Sql Database Files (data and logs) SAS  RAID 1 (2 Drives)  - TempDB (data and logs)   Assuming I can't add additional drives into this server, have I made the best use of the configuration I have available? Or should I consider another scheme here where logs are isolated from the data files, for example?  Update:  For those that requested further hardware details:   The SATA drives (used for the OS / Program partition) are: WD 7200 RPM 3 Gb/s 3.5 Inch SATA The SAS drives used in the other arrays are: Seagate 15K RPM 6 Gb/s 3.5 inch SAS The RAID controller used is an: LSI 9260-8i SAS/SATA 6 Gb 8 port   Update 2:  Based upon the feedback I've received, it looks like I have the following viable options to choose from - I will award the bounty to someone that can tell me which is likely to be the best in the environment that I've outlined:   Leave everything as is - I probably won't do much better  Move my 2 SAS RAID 1 drives into my existing RAID 10 array to have it composed of 6 disks in total  Move my log files onto the SAS RAID 1 and/or relocate TempDB (data or logs) back to the RAID 10