If its for the entire instance, then Alerts, and define a SQL Server Performance Condition Alert on SQLServer:General Statistics, Logical Connections.

For a specific database, maybe something along the lines of...