Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

[SQL2005] equivalent to the SQL 2000 taskpad view in Management St

8 views
Skip to first unread message

Vincent D.

unread,
Dec 4, 2007, 6:29:03 AM12/4/07
to
Hello,

I just installed SQL 2005, and I am looking for the information about my
file usage, as I was able to see in the taskpad view with SQL 2000.

Could you help me on this please ?

Thanks in advance,
Regards,

Vincent

Ekrem Önsoy

unread,
Dec 4, 2007, 7:41:41 AM12/4/07
to
Hello Vincent,

There is no Taskpad in SQL Server 2005. There are Reports instead.

Go to a database and right click on it. You'll see Reports\Standard
Reports\Disk Usage.

I know this looks slower and do not have other stuff (tasks) in it, however
this is the new thing instead of Taskpad in SQL Server 2005.

--
Ekrem Önsoy

"Vincent D." <Vinc...@discussions.microsoft.com> wrote in message
news:313F2B87-34F4-4A2F...@microsoft.com...

Vincent D.

unread,
Dec 4, 2007, 9:57:08 AM12/4/07
to
Hello Ekrem,

Thanks for your help.

My problem is that I have a Siebel database, and I cannot use the 9.0 mode,
I must stay in 8.0 mode. And in 8, I can't see the Disk Usage Report :(

Do you know any workarround ?

Thanks in advance,
Regards,

Vincent

Ekrem Önsoy

unread,
Dec 4, 2007, 11:17:44 AM12/4/07
to
Well, nope for the Reports, sorry. However you can use sp_spaceused sp to
see space info about your db.

Also, you can see the space info from the database properties.

--
Ekrem Önsoy

"Vincent D." <Vinc...@discussions.microsoft.com> wrote in message

news:3E011161-4597-4F78...@microsoft.com...

OgnjenT

unread,
Dec 16, 2007, 8:04:04 AM12/16/07
to
Hello Ekrem,
I have SQL Server 2005 sp2 and my database is in 9.0 mode. On right
click I don't see Reports. I do see reports on Summary window. What is
a difference between standard reports and performance dashboards. I
now that for performance dashboards you need to have a SP2 on your
server and I sow that some servers without sp2 have reports on the
Summary window.

Ognjen

Ekrem Önsoy

unread,
Dec 16, 2007, 10:07:00 AM12/16/07
to
Hello!

There is no Reports in SQL Server Management Studio Express.

You must be using SSMSE to connect to your SQL Server instances so you can't
see Reports when you right click on your databases. You need SSMS to see
Reports menu when you right click on a database.

I encourage you to see the following link to learn more about Performance
Dashboard Reports:
http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en

--
Ekrem Önsoy

"OgnjenT" <Ogn...@gmail.com> wrote in message
news:e6c35d61-2ee9-4b76...@i12g2000prf.googlegroups.com...

Vincent D.

unread,
Dec 17, 2007, 10:35:01 AM12/17/07
to
Hopefully, Siebel finally validated the usage of the 9.0 mode ! :) I'm saved
;-)

OgnjenT

unread,
Dec 18, 2007, 8:27:04 AM12/18/07
to
Hello,
I am using Sql Server 2005 developer edition and I am not using SSMSE
but SSMS.

Ekrem Önsoy wrote:
> Hello!
>
> There is no Reports in SQL Server Management Studio Express.
>
> You must be using SSMSE to connect to your SQL Server instances so you can't
> see Reports when you right click on your databases. You need SSMS to see
> Reports menu when you right click on a database.
>
> I encourage you to see the following link to learn more about Performance
> Dashboard Reports:
> http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0c-4730-8204-e419218c1efc&displaylang=en
>
> --

> Ekrem �nsoy


>
>
>
> "OgnjenT" <Ogn...@gmail.com> wrote in message
> news:e6c35d61-2ee9-4b76...@i12g2000prf.googlegroups.com...
> Hello Ekrem,
> I have SQL Server 2005 sp2 and my database is in 9.0 mode. On right
> click I don't see Reports. I do see reports on Summary window. What is
> a difference between standard reports and performance dashboards. I
> now that for performance dashboards you need to have a SP2 on your
> server and I sow that some servers without sp2 have reports on the
> Summary window.
>
> Ognjen
>

> Ekrem �nsoy wrote:
> > Hello Vincent,
> >
> > There is no Taskpad in SQL Server 2005. There are Reports instead.
> >
> > Go to a database and right click on it. You'll see Reports\Standard
> > Reports\Disk Usage.
> >
> > I know this looks slower and do not have other stuff (tasks) in it,
> > however
> > this is the new thing instead of Taskpad in SQL Server 2005.
> >
> > --

> > Ekrem �nsoy

Ekrem Önsoy

unread,
Dec 18, 2007, 8:44:23 AM12/18/07
to
I don't have the RTM version of SSMS on my test machines so I can't be sure
of that... Did you apply SP2 to your Client Tools (which includes SSMS)?

--
Ekrem Önsoy

"OgnjenT" <Ogn...@gmail.com> wrote in message

news:9957500e-940d-46fb...@r29g2000hsg.googlegroups.com...

Tibor Karaszi

unread,
Dec 18, 2007, 1:26:21 PM12/18/07
to
The reports were moved in sp2 (client) from Summary Window to Object Explorer (right-click). The
performance dashboards report is just a comprehensive plug in report that one can download from MS,
which requires sp2.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Ekrem Önsoy" <ek...@btegitim.com> wrote in message
news:60AF7AFB-12DF-40B2...@microsoft.com...

Ekrem Önsoy

unread,
Dec 18, 2007, 5:54:14 PM12/18/07
to
Good clarification, I did not notice that. Thanks Tibor.

--
Ekrem Önsoy

"Tibor Karaszi" <tibor_please.n...@hotmail.nomail.com> wrote in
message news:7DFB1009-7BE0-453B...@microsoft.com...

OgnjenT

unread,
Dec 19, 2007, 4:45:57 AM12/19/07
to
On Dec 18, 7:26 pm, "Tibor Karaszi"

<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> The reports were moved in sp2 (client) from Summary Window to Object Explorer (right-click). The
> performance dashboards report is just a comprehensive plug in report that one can download from MS,
> which requires sp2.
>
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi

>
> "Ekrem Önsoy" <ek...@btegitim.com> wrote in message
>
> news:60AF7AFB-12DF-40B2...@microsoft.com...
>
>
>
> >I don't have the RTM version of SSMS on my test machines so I can't be sure of that... Did you
> >apply SP2 to your Client Tools (which includes SSMS)?
>
> > --
> > Ekrem Önsoy
>
> > "OgnjenT" <Ognj...@gmail.com> wrote in message

> >news:9957500e-940d-46fb...@r29g2000hsg.googlegroups.com...
> > Hello,
> > I am using Sql Server 2005 developer edition and I am  not using SSMSE
> > but SSMS.
>
> > Ekrem Önsoy wrote:
> >> Hello!
>
> >> There is no Reports in SQL Server Management Studio Express.
>
> >> You must be using SSMSE to connect to your SQL Server instances so you can't
> >> see Reports when you right click on your databases. You need SSMS to see
> >> Reports menu when you right click on a database.
>
> >> I encourage you to see the following link to learn more about Performance
> >> Dashboard Reports:
> >>http://www.microsoft.com/downloads/details.aspx?FamilyId=1d3a4a0d-7e0...
>
> >> --
> >> Ekrem �nsoy
>
> >> "OgnjenT" <Ognj...@gmail.com> wrote in message

> >>news:e6c35d61-2ee9-4b76...@i12g2000prf.googlegroups.com...
> >> Hello Ekrem,
> >> I have SQL Server 2005  sp2 and my database is in 9.0 mode. On right
> >> click I don't see Reports. I do see reports on Summary window. What is
> >> a difference between standard reports and performance dashboards. I
> >> now that for performance dashboards you need to have a SP2 on your
> >> server and I sow that some servers without sp2 have  reports on the
> >> Summary window.
>
> >> Ognjen
>
> >> Ekrem �nsoy wrote:
> >> > Hello Vincent,
>
> >> > There is no Taskpad in SQL Server 2005. There are Reports instead.
>
> >> > Go to a database and right click on it. You'll see Reports\Standard
> >> > Reports\Disk Usage.
>
> >> > I know this looks slower and do not have other stuff (tasks) in it,
> >> > however
> >> > this is the new thing instead of Taskpad in SQL Server 2005.
>
> >> > --
> >> > Ekrem �nsoy
>
> >> > "Vincent D." <Vince...@discussions.microsoft.com> wrote in message

> >> >news:313F2B87-34F4-4A2F...@microsoft.com...
> >> > > Hello,
>
> >> > > I just installed SQL 2005, and I am looking for the information about my
> >> > > file usage, as I was able to see in the taskpad view with SQL 2000.
>
> >> > > Could you help me on this please ?
>
> >> > > Thanks in advance,
> >> > > Regards,
>
> >> > > Vincent- Hide quoted text -
>
> - Show quoted text -

So the dashboards are super set of standard reports?

Thanks for the help

Tibor Karaszi

unread,
Dec 21, 2007, 12:22:46 PM12/21/07
to
> So the dashboards are super set of standard reports?

I wouldn't say "superset". I'd say an extra report, a very good one.

--

Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi

"OgnjenT" <Ogn...@gmail.com> wrote in message

news:5fe783de-071e-401c...@l32g2000hse.googlegroups.com...

OgnjenT

unread,
Dec 23, 2007, 9:05:28 AM12/23/07
to
On Dec 21, 6:22 pm, "Tibor Karaszi"

<tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> > So the dashboards are super set of standard reports?
>
> I wouldn't say "superset". I'd say an extra report, a very good one.
>
> --
> Tibor Karaszi, SQL Server MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/tibor_karaszi
>
> "OgnjenT" <Ognj...@gmail.com> wrote in message
>
> news:5fe783de-071e-401c...@l32g2000hse.googlegroups.com...
> On Dec 18, 7:26 pm, "Tibor Karaszi"
>
>
>
>
>
> <tibor_please.no.email_kara...@hotmail.nomail.com> wrote:
> > The reports were moved in sp2 (client) from Summary Window to Object Explorer (right-click). The
> > performance dashboards report is just a comprehensive plug in report that one can download from
> > MS,
> > which requires sp2.
>
> > --
> > Tibor Karaszi, SQL Server
> > MVPhttp://www.karaszi.com/sqlserver/default.asphttp://sqlblog.com/blogs/...
> Thanks for the help- Hide quoted text -

>
> - Show quoted text -

I found some extra reports created by Gregory A. Larsen at
http://sqlserverexamples.com/v1/downloadDBADashBoard.html

0 new messages