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

beware: SQL2005 management studio not 2000 compatible

using 2005 management studio i made changes to an 8 step job on SQL 2000
server. I inserted a new step into position 8 and then tried to save it.
SQL2005 management told me that some feature was not supported on SQL 2000
so i pressed cancel. at this point both SQL 2005 management studio and SQL
200) enterprise management both report a 4 step job.
It is going to take me hours to restore the 8 step job from a backup so that
it can be re-inserted into the live DB.
what a fiasco.
Leon
Leon McCalla (leonmccalla@.hotmail.com.junkfilter) writes:
> using 2005 management studio i made changes to an 8 step job on SQL 2000
> server. I inserted a new step into position 8 and then tried to save it.
> SQL2005 management told me that some feature was not supported on SQL 2000
> so i pressed cancel. at this point both SQL 2005 management studio and SQL
> 200) enterprise management both report a 4 step job.
> It is going to take me hours to restore the 8 step job from a backup so
> that it can be re-inserted into the live DB.
That's bad. That would indicate that there is no transaction handling. I
think this is quite a serious bug. Please go to http://connect.microsoft.com
and file a bug for this. Try to be as specific as possible. Best if you
can give a complete scenario which reproduces the problem. (A two-step job
should be sufficient, I guess.) I know that this will take even more time,
but if Microsoft does not get to know about the problem, they can't mend
their ways.
Erland Sommarskog, SQL Server MVP, esquel@.sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

better table management (partitions?)

Hi,

For my work I am now learning Sql server 2005 and I have been given a database that has been set up by someone else to work with. It is my job to get the database ready for use in reports.

My problem is that the current database has one huge table with almost 8GB of data. The table contains data from 2004 to present (and growing) from 14 different countries. The reports we use are mostly per country, but we also want to compare the 14 countries to eachother for say, whole 2006. At the moment the table is stored in one single file instead of using partitions.

I believe partitions can give a good performance boost when running the queries. But how do I do this? Currently the country codes are just plain text, can they be used for partitions?

Any advice would be welcome,

Thanks!

It sounds like you could benefit from partitioning. You can learn more here:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/sql2k5partition.asp

If this post answers your question, make sure you mark it "answered" so others can find it quickly.

Thanks -

Buck Woody
http://www.buckwoody.com

|||

Thanks for your reply.

The table has over 5 million records and is still growing, so partitioning seems nice.

However, they are using SQL 2005 standard edition, while only enterprise can use partitioning.

Are there any other ways to make the queries run faster?

|||

Use the Database Tuning Advisor in SQL Server 2005 to see if there are any changes you can make to help. There's a full article about that here:

http://msdn2.microsoft.com/en-us/library/ms173494.aspx

Buck Woody

Beta 2 Management studio navigation

A couple of questions:
-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
-- Where do you go to set up a new DTS script if it is not done with the wizard?
Thanks.
If you have a question about SQL Server 2005 Beta 2, please ask it in
the newsgroups that have been established for it. You can find out how
to access those newsgroups where you got the beta version of SQL Server
2005.
Steve Kass
Drew University
bogus_boy wrote:

>A couple of questions:
>-- I can see how to desgin a table in the tree, but how do you quickly view all rows in a table like you could in enterprise manager?
>-- Where do you go to set up a new DTS script if it is not done with the wizard?
>Thanks.
>