BIDS and SSMS very slow on Windows XP SP2

Hi,

opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action.

Is anybody aware of this problem? We didn't have those problems on Win2000 so I guess it is XP related.

Any ideas?

Regards

Norbert Bender

http://www.sql-server-performance.com//faq/?f=144|||

I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea?

Regards

Norbert

|||

I would guess sometimes it take forever, when I had that problem I've uninstalled and resinstalled the tools which gave me senisble performance on that aspect.

|||

I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM.

Next, if you are running SSMS on the same machine as SQL Server, and if this is a development environment, I would limit the amount of RAM available to SQL Server. By default, SQL Server will use every available byte of memory on the machine if it thinks it needs it. This is a good thing for production servers where server performance is everything, but this tends to starve other applications running on the server. On my laptop, I limit the server to 128 MB of RAM, which is sufficient for testing purposes. If you are working with a production server, consider running SSMS or BIDS on a different machine and connecting remotely to the server.

Next, consider what else you are running in the background. If you are running a large number of applications, you might not have a lot of memory left for SSMS or BIDS. If you are running some application that is using the disk drive continuously, that can hurt performance too. The file system runs at very high priority and can monopolize the system if there are lot of reads and writes going on, particularly on single processor machines. My laptop becomes basically unusable while I'm compiling a large code-base, for example.

Last, if possible, make sure your machine can connect to the internet. The .NET runtime validates that the certificates that code is signed with are valid when applications start. Part of this operation requires the runtime to get the list of revoked certificates from the http://crl.microsoft.com website to make sure the code wasn't signed with a revoked certificate. (Some fake certificates were issued in Microsoft's name a few years back, so this is a real concern.) If the runtime can't quickly connect to the website, it can take up to 45 seconds for the operation to time-out completely. You can turn this check off, but it's fairly dangerous to do that on machines that are sometimes connected to the internet.

Hope this helps,
Steve

|||

Thanks for those detailed information. I guess the last issue is it, as the account I am using is not the one, which is allowed to connect to the internet.

I will try this and I will give you feedback asap.

Regards nad thanks

Norbert

|||

Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do not have memory intensive apps running. I think I will reinstall the whole software maybe this helps

Regards

Norbert

BIDS and SSMS very slow on Windows XP SP2

Hi,

opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action.

Is anybody aware of this problem? We didn't have those problems on Win2000 so I guess it is XP related.

Any ideas?

Regards

Norbert Bender

http://www.sql-server-performance.com//faq/?f=144|||

I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea?

Regards

Norbert

|||

I would guess sometimes it take forever, when I had that problem I've uninstalled and resinstalled the tools which gave me senisble performance on that aspect.

|||

I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM.

Next, if you are running SSMS on the same machine as SQL Server, and if this is a development environment, I would limit the amount of RAM available to SQL Server. By default, SQL Server will use every available byte of memory on the machine if it thinks it needs it. This is a good thing for production servers where server performance is everything, but this tends to starve other applications running on the server. On my laptop, I limit the server to 128 MB of RAM, which is sufficient for testing purposes. If you are working with a production server, consider running SSMS or BIDS on a different machine and connecting remotely to the server.

Next, consider what else you are running in the background. If you are running a large number of applications, you might not have a lot of memory left for SSMS or BIDS. If you are running some application that is using the disk drive continuously, that can hurt performance too. The file system runs at very high priority and can monopolize the system if there are lot of reads and writes going on, particularly on single processor machines. My laptop becomes basically unusable while I'm compiling a large code-base, for example.

Last, if possible, make sure your machine can connect to the internet. The .NET runtime validates that the certificates that code is signed with are valid when applications start. Part of this operation requires the runtime to get the list of revoked certificates from the http://crl.microsoft.com website to make sure the code wasn't signed with a revoked certificate. (Some fake certificates were issued in Microsoft's name a few years back, so this is a real concern.) If the runtime can't quickly connect to the website, it can take up to 45 seconds for the operation to time-out completely. You can turn this check off, but it's fairly dangerous to do that on machines that are sometimes connected to the internet.

Hope this helps,
Steve

|||

Thanks for those detailed information. I guess the last issue is it, as the account I am using is not the one, which is allowed to connect to the internet.

I will try this and I will give you feedback asap.

Regards nad thanks

Norbert

|||

Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do not have memory intensive apps running. I think I will reinstall the whole software maybe this helps

Regards

Norbert

BIDS and SSMS very slow on Windows XP SP2

Hi,

opening SQL Server Management Studio 2005 or Business Intelligence Development Studio 2005 on my Windows XP SP2 Professional Edition is extremely slow. Espacially in BIDS it take several seconds for each action.

Is anybody aware of this problem? We didn't have those problems on Win2000 so I guess it is XP related.

Any ideas?

Regards

Norbert Bender

http://www.sql-server-performance.com//faq/?f=144|||

I added the /nosplash option but it didn't change anything. It is still very slow. Any other idea?

Regards

Norbert

|||

I would guess sometimes it take forever, when I had that problem I've uninstalled and resinstalled the tools which gave me senisble performance on that aspect.

|||

I would start by making sure you have sufficient memory on the machine. Both SSMS and BIDS have a large number of .NET managed code components. .NET applications use quite a bit of memory, so they are much more performant on machines with lots of memory. SSMS runs fine on my 1.2 GHz P3 laptop, but it has 1GB of RAM.

Next, if you are running SSMS on the same machine as SQL Server, and if this is a development environment, I would limit the amount of RAM available to SQL Server. By default, SQL Server will use every available byte of memory on the machine if it thinks it needs it. This is a good thing for production servers where server performance is everything, but this tends to starve other applications running on the server. On my laptop, I limit the server to 128 MB of RAM, which is sufficient for testing purposes. If you are working with a production server, consider running SSMS or BIDS on a different machine and connecting remotely to the server.

Next, consider what else you are running in the background. If you are running a large number of applications, you might not have a lot of memory left for SSMS or BIDS. If you are running some application that is using the disk drive continuously, that can hurt performance too. The file system runs at very high priority and can monopolize the system if there are lot of reads and writes going on, particularly on single processor machines. My laptop becomes basically unusable while I'm compiling a large code-base, for example.

Last, if possible, make sure your machine can connect to the internet. The .NET runtime validates that the certificates that code is signed with are valid when applications start. Part of this operation requires the runtime to get the list of revoked certificates from the http://crl.microsoft.com website to make sure the code wasn't signed with a revoked certificate. (Some fake certificates were issued in Microsoft's name a few years back, so this is a real concern.) If the runtime can't quickly connect to the website, it can take up to 45 seconds for the operation to time-out completely. You can turn this check off, but it's fairly dangerous to do that on machines that are sometimes connected to the internet.

Hope this helps,
Steve

|||

Thanks for those detailed information. I guess the last issue is it, as the account I am using is not the one, which is allowed to connect to the internet.

I will try this and I will give you feedback asap.

Regards nad thanks

Norbert

|||

Thanks for the hints. I checked the permissions for the account and they can access the internet, so I guess, this isn't the solution. My client has has 1 GB to as RAM and ususally I do not have memory intensive apps running. I think I will reinstall the whole software maybe this helps

Regards

Norbert

BI Studio: Poor Performance When Opening a Solution

When I am opening a Business Intelligence Solution it takes up to 6 minutes
until the system is ready to work.
The first 4 minutes I see Visual Studio with the grey background. In the
remaining time the packages appear but don't accept any input. Meanwhile
Visual Studio is reporting that it is busy and is waiting for an internal
operation to complete.
Any idea how to speed up this process?
Stefan Bublitz
does your cube metadata is big?
My metadata takes 10Mb and required few minutes to be opened.
"SBublitz" <SBublitz@.discussions.microsoft.com> wrote in message
news:095B0A32-78DE-418B-854B-243798CAF2C0@.microsoft.com...
> When I am opening a Business Intelligence Solution it takes up to 6
> minutes
> until the system is ready to work.
> The first 4 minutes I see Visual Studio with the grey background. In the
> remaining time the packages appear but don't accept any input. Meanwhile
> Visual Studio is reporting that it is busy and is waiting for an internal
> operation to complete.
> Any idea how to speed up this process?
> Stefan Bublitz
|||I browsed the newsgroups in the meantime and I found a hint that I tried out:
I uninstalled the SSIS SP1 and I re-installed SSIS without SP1.
I don't know if this has been the cause of the problem but obviously it
solved it...
(I found entries in the event log regarding DCOM and MsDtsServer).
Stefan Bublitz
"Jeje" wrote:

> does your cube metadata is big?
> My metadata takes 10Mb and required few minutes to be opened.
> "SBublitz" <SBublitz@.discussions.microsoft.com> wrote in message
> news:095B0A32-78DE-418B-854B-243798CAF2C0@.microsoft.com...
>
|||oh you talk about an SSIS solution not an SSAS one.
Sorry for this mistake.
and what about the SP2?
with SSIS I suffer slow opening only if my solution was closed and if my
some packages are opened. When I reopen the solution, this reopen all these
packages and takes few times because SSIS validate each package.
You can improve this by changing the validate metadata option of your
connection to false (true by default until SP2, but after a package is
created you have to change this your self)
You can also check the "work offline" option before opening your big
solution.
"SBublitz" <SBublitz@.discussions.microsoft.com> wrote in message
news:3A16F4D2-5655-43DD-ACD7-1035EFBBA835@.microsoft.com...[vbcol=seagreen]
>I browsed the newsgroups in the meantime and I found a hint that I tried
>out:
> I uninstalled the SSIS SP1 and I re-installed SSIS without SP1.
> I don't know if this has been the cause of the problem but obviously it
> solved it...
> (I found entries in the event log regarding DCOM and MsDtsServer).
> --
> Stefan Bublitz
>
> "Jeje" wrote:

BI Studio: Poor Performance When Opening a Solution

When I am opening a Business Intelligence Solution it takes up to 6 minutes
until the system is ready to work.
The first 4 minutes I see Visual Studio with the grey background. In the
remaining time the packages appear but don't accept any input. Meanwhile
Visual Studio is reporting that it is busy and is waiting for an internal
operation to complete.
Any idea how to speed up this process?
Stefan Bublitzdoes your cube metadata is big?
My metadata takes 10Mb and required few minutes to be opened.
"SBublitz" <SBublitz@.discussions.microsoft.com> wrote in message
news:095B0A32-78DE-418B-854B-243798CAF2C0@.microsoft.com...
> When I am opening a Business Intelligence Solution it takes up to 6
> minutes
> until the system is ready to work.
> The first 4 minutes I see Visual Studio with the grey background. In the
> remaining time the packages appear but don't accept any input. Meanwhile
> Visual Studio is reporting that it is busy and is waiting for an internal
> operation to complete.
> Any idea how to speed up this process?
> Stefan Bublitz|||I browsed the newsgroups in the meantime and I found a hint that I tried out
:
I uninstalled the SSIS SP1 and I re-installed SSIS without SP1.
I don't know if this has been the cause of the problem but obviously it
solved it...
(I found entries in the event log regarding DCOM and MsDtsServer).
Stefan Bublitz
"Jeje" wrote:

> does your cube metadata is big?
> My metadata takes 10Mb and required few minutes to be opened.
> "SBublitz" <SBublitz@.discussions.microsoft.com> wrote in message
> news:095B0A32-78DE-418B-854B-243798CAF2C0@.microsoft.com...
>|||oh you talk about an SSIS solution not an SSAS one.
Sorry for this mistake.
and what about the SP2?
with SSIS I suffer slow opening only if my solution was closed and if my
some packages are opened. When I reopen the solution, this reopen all these
packages and takes few times because SSIS validate each package.
You can improve this by changing the validate metadata option of your
connection to false (true by default until SP2, but after a package is
created you have to change this your self)
You can also check the "work offline" option before opening your big
solution.
"SBublitz" <SBublitz@.discussions.microsoft.com> wrote in message
news:3A16F4D2-5655-43DD-ACD7-1035EFBBA835@.microsoft.com...[vbcol=seagreen]
>I browsed the newsgroups in the meantime and I found a hint that I tried
>out:
> I uninstalled the SSIS SP1 and I re-installed SSIS without SP1.
> I don't know if this has been the cause of the problem but obviously it
> solved it...
> (I found entries in the event log regarding DCOM and MsDtsServer).
> --
> Stefan Bublitz
>
> "Jeje" wrote:
>