Dan Waters
df.waters at comcast.net
Mon Dec 5 12:37:08 CST 2011
I wondered about this myself. I'm using SS 2008 R2 Express. I found: Right-click on the SQL Server Instance name is SSMS. Activity Monitor is the 5th item on the list. Look at Recent Expensive Queries. Good Info. Then right-click one of the queries and select Show Execution Plan - and you get a diagram! You can also select Edit Query Text to see what the actual SQL statement is. Thanks! Dan -----Original Message----- From: dba-sqlserver-bounces at databaseadvisors.com [mailto:dba-sqlserver-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: Monday, December 05, 2011 11:47 AM To: Discussion concerning MS SQL Server Subject: Re: [dba-SQLServer] Users in SQL Server Cool, except that my management folder does not have Activity Monitor as an object under it. John W. Colby Colby Consulting Reality is what refuses to go away when you do not believe in it On 12/5/2011 12:33 PM, David McAfee wrote: >> From the SSMS Object Explorer, you can click on Management ->Activity > Monitor > > You can see all active users/processes. > > You can filter by database or user, right click on a process and Kill > it if you need. > > All done via the GUI, with nothing typed except a user or database > name if you chose to filter by one. > > D > > > > > > On Mon, Dec 5, 2011 at 9:21 AM, jwcolby<jwcolby at colbyconsulting.com> wrote: > >> Our (or at least my) problem is that MS is not spending enough time >> on the GUI. When I realized I needed to get the users and their >> rights out of the database into the server, I tried to click / hold / >> drag and drop the user from the database security area into the server security area. >> >> Makes sense right? >> >> We have been dragging and dropping for 15 years now in Windows, >> longer than that in the MAC world. Visual Studio and C# uses drag and >> drop, Access uses drag and drop. But no, in SQL Server we have to go >> figure out how this stuff even works, then how to use command line or >> query crap to type in arcane syntax into a dev environment that >> basically gives you a "didn't work, try again" error message if anything goes wrong. >> >> > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > > _______________________________________________ dba-SQLServer mailing list dba-SQLServer at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-sqlserver http://www.databaseadvisors.com