Posts Tagged: query

I encountered a SQL server with multiple instances that was using a lot of memory. Some of the instances were not limited in their memory usage. I found a nice SQL query to lookup how much memory the instances were actually using.

I’m not really into timesyncing but I ran into an issue on my network that my time was off 10 minutes on my DC’s and servers. With the w32tm /query /source command I could see that my machines all were using the DC with the PDC emulator role enabled. The DC was using the VM IC Time Synchronization Provider as time source.