Tag Info

New answers tagged


Since 2008, SQL Server answers on dynamic ports by default. You can set static ports in SQL Server Configuration Manager. To turn Dynamic Ports off, erase the 0 that appears on the right side, above the port number (in this case, 1433). Once you have static ports, you'll need to enable access to 1433 TCP and 1434 UDP.


Which version of SCOM are you using? In my 2007 install, its a view not a table. Use adtServer.dvAll5 which contains only the first 5 event params, or adtServer.dvAll which has ALL params, but it slower.

Top 50 recent answers are included