Monday, March 19, 2012

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

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
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." <VincentD@.discussions.microsoft.com> wrote in message
news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.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
|||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" 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." <VincentD@.discussions.microsoft.com> wrote in message
> news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
>
|||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." <VincentD@.discussions.microsoft.com> wrote in message
news:3E011161-4597-4F78-94A6-15FBA9E7A9CC@.microsoft.com...[vbcol=seagreen]
> 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" wrote:
|||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:[vbcol=seagreen]
> 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." <VincentD@.discussions.microsoft.com> wrote in message
> news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
|||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" <OgnjenT@.gmail.com> wrote in message
news:e6c35d61-2ee9-4b76-9286-dbb9e5f83ac2@.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:[vbcol=seagreen]
> 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." <VincentD@.discussions.microsoft.com> wrote in message
> news:313F2B87-34F4-4A2F-9DB4-E268DC4B4424@.microsoft.com...
|||Hopefully, Siebel finally validated the usage of the 9.0 mode ! I'm saved
;-)
"Ekrem ?nsoy" wrote:

> 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." <VincentD@.discussions.microsoft.com> wrote in message
> news:3E011161-4597-4F78-94A6-15FBA9E7A9CC@.microsoft.com...
>
|||Hello,
I am using Sql Server 2005 developer edition and I am not using SSMSE
but SSMS.
Ekrem ?nsoy wrote:[vbcol=seagreen]
> 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" <OgnjenT@.gmail.com> wrote in message
> news:e6c35d61-2ee9-4b76-9286-dbb9e5f83ac2@.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:
|||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" <OgnjenT@.gmail.com> wrote in message
news:9957500e-940d-46fb-8d2a-f549e243aa51@.r29g2000hsg.googlegroups.com...
Hello,
I am using Sql Server 2005 developer edition and I am not using SSMSE
but SSMS.
Ekrem ?nsoy wrote:[vbcol=seagreen]
> 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" <OgnjenT@.gmail.com> wrote in message
> news:e6c35d61-2ee9-4b76-9286-dbb9e5f83ac2@.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:

No comments:

Post a Comment