SSMS slow to start after SP1 upgrade.



  • 1. Simple sql server backup/restore
    A very simple thought, stop all SQL services, copy or zip the folder structure, restart all SQL services, in reverse to restore. Questions. I've tried this before and mostly this works fine when restoring but in some cases sql server keeps generating errors, why? what have I missed in the zip/copy process? file attributes? registry entries? the sql server databases are no more then a bunch of files stored in folders so what might be missing and where could this be located? (w2k, w3k, sbs, sql2000, sql2005)
  • 2. Connect to SQL Server from machine not in domain
    I am attempting to connect to a SQL Server on a machine for whichI have a VPN connection to. My machine is not in the domain, although my userid/password match that of the domain I am connected to. I have validated this by connecting to a share on the SQL Server (which is a 2005 implementation) using a "net use \\server\share /user:domain \myuser" and not supplying the password. I am receiving the error "Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection. (Microsoft SQL Server, Error: 18452). Any help would be appreciated.
  • 3. SQL query for this purpose
    We have two tables and data similar as below Table: MASTER -------------------- Master_id - Dsite -------------------- 1 - NewYork 2 - Tokiyo -------------------- Table: DETAILS --------------------------------- Master_id - item_id - owner --------------------------------- 1 - id1 - James 1 - id1 - Eva 1 - id2 - Dave 1 - id3 - John 2 - id1 - Suzy 2 - id1 - Smith 2 - id4 - Ravi --------------------------------- We want to list the result set as all those item_ids and owners for which the item_id is associated with more than one masterids. So the result for the above example would be as below - Item_id - Owner Id1 - James Id1 - Eva Id1 - suzy Id1 - smith How should one write SQL query for such scenario? Thanks in advance for your help.
  • 4. Database Restore Error
    Hello when i try to restore the wss database in sql, i am getting following error. any idea? Warning: The join order has been enforced because a local join hint is used Using STSADM regards Gopi
  • 5. Master db defaults to "simple" recovery model
    I was looking at the recovery model for various databases and noticed that all system databases other than model are set to "simple" recovery by default. Is there a risk for doing this or should I set them all to "full"?

SSMS slow to start after SP1 upgrade.

Postby PSPDBA » Tue, 23 May 2006 21:29:18 GMT

Before upgrading to SP1 on Sql 2005, it took about 5 seconds to launch
SSMS logged in remotely to our quad Xeon 2.7 4G ram server.  SQL 2k5 is
the only thing on the server, and it is currently only being used by 2
DBAs for testing.  Basically the server has no load on it at all - CPU,
memory, disk I/O all at minimal levels.

After SP1, it takes around 30 seconds to launch SSMS.  Response from
SQL to our test applications during this time is fine, no issues what
so ever - so although annoying to the DBA's, it's not mission critical.
 This server goes live June 1 and I'd like some opinions on what may be


Similar Threads:

1.Slow backups after upgrade to Windows Server 2003 SP1


   I recently upgraded a server to Windows Server 2003 SP1.  The server is 
SQL Server 2000 SP4 and ARCServe 9.01 SQL Agent.

    Transaction Log Backups on this server have slowed down by about 50X.  
Throughput has gone from about 300MB/minute to about 6 MB/minute.

    I tried upgrading the SQL Agent to ARCServe 9.01 SP1, but that didn't 
seem to

    I have another server that had Windows Server 2003 installed on it from 
start, recently upgraded to SP1, running ARCServe 11 SQL Agent.  That server
has no problems with backup.

    I know this sounds like an ARCServe issue, but I'd like to avoid 
upgrading to 
ARCServe 11 if I can.  Has anyone else seen anything similar?  If so, how 
did you 
work around it?




2.Is it imp to upgrade windows 2003 with SP1 before upgrading sql2k

Is there any recommendation that we should upgrade windows 2003 with SP1 
first before upgrading SQL server 2000 SP4?

Please let me know if there is any information related to this.


3.After installing SQL Server 2005 SP1 SSMS cannot connect to the se

4.SSMS 2005 on Vista SP1 can't find new named cluster instance


I have two Vista SP1 machines that have SSMS 2005 installed on them.  These 
two machines (both used by developers) cannot see my new named SQL cluster 
instance when trying to connect using SSMS.  Every other PC in the office 
with SSMS can find the instance.  The two trouble machines can ping the 
virtual cluster by name.  They just can't pull up the instance in SSMS.  Both 
developers have permissions to connect to the instance.  One developer with a 
trouble PC says he can run a query against the instance from the same trouble 
PC using Visual Studio 2005.  I can't figure out what's going on but I need 
to fix this.  Any suggestions?

5.SSMS and BI Studio very very slow

1) It takes about 10 seconds for the in-context menu to appear when I 
right-click on a table. On subsequent attempts, it appears almost immediately.

2) It takes more than 10 seconds to save a new table design in SSMS (right 
click on Tables, New Table..., wait 5 seconds right there, design your table, 
click on the floppy icon to save it, and wait 15 seconds)

3) I often get the following message in BI studio "Microsoft Visual Studio 
is busy. Microsoft Visual Studio is waiting for an internal operation to 
complete. If you regularly encounter the delay during normal usage, please 
report the problem to Microsoft". And that shows up when I click on a data 
flow transformation in design mode.

4) When I click on the "Start debugging" of an SSIS package, it takes ages 
to start executing. The execution itself is really fast (5 million rows in 
less than a minute through several transformations)

I have numerous examples of very basic operations that take ages to 
complete. What could be possibly going on? I have now turned off the "MS 
customer feedback " from the help menu, to no avail.

This has been going on since day one.

I'm working locally on the server with a remote desktop connection, a dual 
Xeon with 4 Gig memory, and doing nothing but development. I have verified 
that the System Idle Process is above 95% during all the cases indicated 
Win 2003 Enterprise edition, SQL Server 2005 Enterprise.

6. Start SSMS error

7. SSMS screen refresh rate very slow

8. Not able to start SSMS using user from Sql server



Who is online

Users browsing this forum: No registered users and 93 guest