Milena Petrovic (@SQLMillie) header
Milena Petrovic (@SQLMillie) profile picture

Product support engineer at ApexSQL SQL enthusiast, Mediterranean food lover, passionate skier, coffee & tea addict

Joined June 2010
#SQLServer dashboard and other useful performance information is available in #SSMS Standard Reports
1
Info that Data Collector shows for executed queries #SQLServer
1
1
SQL Recompilations in Performance Monitor #SQLServer
Detecting #SQL recompilations using Windows Performance Monitor
1
1
Windows Performance Monitor can show live, real time data as well as data stored in *.blg, *.csv, or *.tsv log files
#SQLServer monitoring using Activity Monitor in SSMS
1
1
Alerting in #SQLServer is brought by Alerts in SQL Server Agent
The Activity Monitor Process pane context menu provides tracing the selected process in #SQLServer Profiler
DBCC SHOW_STATISTICS ("Person.Address", PK_Address_AddressID) #SQLServer