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 wrong. Thanks!
SSMS slow to start after SP1 upgrade.
1 posts
• Page 1 of 1
- delphi
- network
- ada
- windows ce
- Microsoft publisher
- WINDOWS SERVER
- as400
- WINDOWS VISTA
- Windows
- MS Office Access
Jump to:
- 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"?
Next
SSMS slow to start after SP1 upgrade.
by PSPDBA » Tue, 23 May 2006 21:29:18 GMT
Similar Threads:
1.Slow backups after upgrade to Windows Server 2003 SP1
Greetings,
I recently upgraded a server to Windows Server 2003 SP1. The server is
running
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
help.
I have another server that had Windows Server 2003 installed on it from
the
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?
Regards,
Jonathan
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. Thanks! Shriniwas
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
All, 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 above. Win 2003 Enterprise edition, SQL Server 2005 Enterprise.
1 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 93 guest