February 25, 2009 at 4:28 am
I need to regularly check on the size of the database and transaction logs but I can't find Taskpad in SSMS! Has any one any idea where it is?
Madame Artois
February 25, 2009 at 4:32 am
February 25, 2009 at 5:00 am
Sometimes you cannot see the wood for the trees.
Thanks for the help
Madame Artois
February 25, 2009 at 5:00 am
We don't have task pad in SSMs. We have to use SP_helpdb it will give the size of all the dabases. if you want further details then pass individual database to this SP.
February 25, 2009 at 5:19 am
iainthepitman (2/25/2009)
http://www.sql-server-performance.com/faq/taskpad_view_ssms_p1.aspx
I'm using 2k5 at sp2... and there's no "Summary" selection in the "View" menu... has anyone actually tried this?
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2009 at 5:21 am
I've noticed that they keep removing shortcuts as well (although I haven't gone to see if they're addable...), such as CTL + B in SQL 7 and 2000 to size the results pane, and CTL + SHIFT + L for lower case.
February 25, 2009 at 5:23 am
yep. its there in RTM.
February 25, 2009 at 6:04 am
It was there for me; I thought I was having a senior moment
Madame Artois
February 25, 2009 at 6:09 am
Thanks folks... darned thing isn't there for me.
--Jeff Moden
Change is inevitable... Change for the better is not.
February 25, 2009 at 7:11 am
I'm using 2k5 at sp2... and there's no "Summary" selection in the "View" menu... has anyone actually tried this?
I belive it was changed in SP2.
Right click on the database, select Reports, Standard Reports.
The details are there albeit in several reports :crazy:
Far away is close at hand in the images of elsewhere.
Anon.
February 25, 2009 at 7:24 am
p.s. SimonSabin has published a custom taskpad report on his blog at
http://sqlblogcasts.com/blogs/simons/archive/2006/11/23/Taskpad-view-version2.aspx
Far away is close at hand in the images of elsewhere.
Anon.
February 25, 2009 at 6:24 pm
David Burrows (2/25/2009)
I'm using 2k5 at sp2... and there's no "Summary" selection in the "View" menu... has anyone actually tried this?
I belive it was changed in SP2.
Right click on the database, select Reports, Standard Reports.
The details are there albeit in several reports :crazy:
Heh... and yet another useful, very well documented feature bites the dust.
Thanks, David.
--Jeff Moden
Change is inevitable... Change for the better is not.
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy