is there a tool / feature of sql server 2005 that allows me to see all objects in memory, locks, users logged in at present and anything else i might need to monitor for things like deadlocks or resource intensive sprocs
monitoring and administrating sql server
Hot Topic
- SMTP Authentication in Send Mail Task
- I've got the June CTP Sql 2005 but SSIS doesn't work
- Report Viewer Issue in Visual Studio 2005 Beta 2. for Microsoft Reporting Services
- Some strange problems
- No snapshot automaticly updated
- MS Access & SQL Server 2005
- Getting data from Access database and copying to SQL Server dataset - Data Type problem
- Deadlock Issues
- Display quote in data using select statement
- How to invoke C# code from SSIS? Can we script in C# for Script Task?
SQL Server
- DTS Packages in SQL 2005 - what are they now, etc
- Announcing SQL Server Everywhere Edition
- SQL Express Capabilities
- SQL Server 2000 connection
- Help building a #temp table
- Hr=80004005 ERR:OpenDB failed getting pub version 28627
- Problem Reading .CSV file data from reporting services
- Grouping question
- Datareader Query Timeout
- (Report Model Deployment Error) The value of parameter 'DataSources' is not valid
monitoring and administrating sql server