SysAdmin info and tips
Tuesday, October 7, 2014
query TCP UDP ports in Windows
›
Portqry.exe is a command-line utility that you can use to help troubleshoot TCP/IP connectivity issues The utility reports the port s...
1 comment:
Sunday, October 5, 2014
check DataBase allocated and unused size
›
SET NOCOUNT ON ; SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ; -- create temporary table that will store data space used informatio...
Why your SQL Log files are growing too big?
›
Every SQL Server database has at least two files; a data file and a transaction log file. The data file stores user and system data whil...
How to make Windows 8 understand you ARE the Administrator
›
This tweak goes well when UAC is already disabled and is assumed you have done so already. If not: http://www.howtogeek.com/howto/wind...
Using NSLOOKUP to query and verify MX records
›
1) From a command prompt type ‘nslookup’. 2) By default this will connect to the client primary DNS server. if you are require...
Solid State Drives
›
If a solid-state drive doesn’t have any moving parts, how does it store data? Instead of using motors and magnets, they use electrical...
1 comment:
Setup Performance Monitor to always collect Server performance statistics
›
How can we setup Performance Monitor to collect data all of the time, so we can go back and review the data when needed? 1. Click Star...
›
Home
View web version
