.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan
Santhakumar Munuswamy
Fauzul Azmi
Asad Ali
Post New Web Links

SQL Server 2008 client very slow on new Win7 PC

Posted By:      Posted Date: September 29, 2010    Points: 0   Category :Sql Server
 

I installed SQL Server 2008 Management Studio on a brand new PC (HP ProBook 6540b with an i5 CPU and 2GB RAM) running Windows 7 x86. A script that runs some stored procedures on a Windows 2008 x64 server (also SQL 2008) and which returns about 10 result sets takes a fraction of a second on our old PC's, including one that runs Windows 7 (the rest are XP and Vista). But on this PC, it takes 30 seconds! I installed the client tools the same way as always, and applied SP1. I disabled the Windows Firewall and anti virus, and then disabled the Aero interface, and it is still slow (now about 15 seconds). Non-SQL functions are faster, e.g. copying files over the network is almost 3x faster than on my old PC, so there doesn't seem to be a general speed problem with the PC.

Do I need to change any settings for Windows 7? I ran the configuration manager, but the settings look the same as on the old PC. I disabled shared memory (I think this is just for a local database server?), but this made no difference.

Any ideas? Thanks!

 

 




View Complete Post


More Related Resource Links

Using SQL Server 2008 R2 client with Enterprise Library

  

All,

I am modifying an existing application that uses SQL Server 2008 as the database and Enterprise Library 4.1 for Data Access .

What I need to do is to make it use the SQL Server 2008 R2 client to take advantage of out of the box failover capabilities.

Any idea how I can accomplish this?

Thanks



error while installing sql server 2008 r2 on win7

  
what can i do? i had .net framework 3.5 sp1 details is: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Configuration.ConfigurationErrorsException: An error occurred creating the configuration section handler for userSettings/Microsoft.SqlServer.Configuration.LandingPage.Properties.Settings: Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. (C:\Users\seven\AppData\Local\Microsoft_Corporation\LandingPage.exe_StrongName_ryspccglaxmt4nhllj5z3thycltsvyyx\10.0.0.0\user.config line 5) ---> System.IO.FileNotFoundException: Could not load file or assembly 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089' or one of its dependencies. The system cannot find the file specified. File name: 'System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089'    at System.Configuration.TypeUtil.GetTypeWithReflectionPermission(IInternalConfigHost host, String typeString, Boolean throwOnError)    at System.Configuration.RuntimeConfigurationRecord.RuntimeConfigurationFactory.Init(RuntimeConfigurationRecord configRecord, FactoryRecord factoryRecord)    at System.Configuration.RuntimeC

report viewer error / visual web developer 2008 / sql server 2008 / report viewer add on / win7 x64

  
hi, i decided to export my local site to iis today, the process wasn't smooth.   anyway. i was able to access my site, the db tables are working as i am able to create new records and retrieve them. my main problem now is with the report object. i've tried the work around found here : http://support.microsoft.com/kb/2002980.. it helped sort of. i used to have only a big page of error before i did the work around, now i am able to see half of the report (the report interface) but the contents, the field are filled with 404 errors. any idea how i can fix this??                  

SQL Server 2008 R2 deploying any version of sharepoint results in extremly slow DB creation

  
Hello, When installing any version of Sharepoint(2007,2010) during the "Creating Configuration Database" Step it takes over 10 hours to complete.  Then creating a web app takes just as long. and the sites are extreemply slow.  Environment: 1) DB Server - SQL Server 2008 R2 on Windows Server 2008 R2 2) Webserver - to host Sharepoint 2010 on Windows Server 2008 R2 The Servers are on the same network and running with lots of horsepower, disk and memory.  Are there any know issues with this and should we install Cummulative Update 3? Maybe that has a fix.  We exhausted all our options and need justification to apply the CU3 hotfix(s). Thanks for your help.

Slow sql-server after upgrade from SQL-Server 2005 x64 standard to SQL-Server 2008 R2 x64 enterprise

  

We moved our databases to new hardware today (using copy database wizard)

 

The new hardware should be better than the old one.

We went from 28 GB ram to 128 GB.

We went from 16 cores to 32 cores (with even more cache etc.). We also moved from external SAN with 40 disks to intern disks (8 Samsung SS805 100gb ssd slc)

                             According to our own metrics we could get twice the IO using IO m

Why call web serivce so slow on windows2003 sp2(or windows server 2008) iis6?

  

my web service reference a ATL COM dll(provide many interface to access MS Sql server).

i create a ATL Activex Control call the web service.

when i test IIS server, the problem appears:

1 when i use win2003 (no server packs). the activex call the web serivce fast, less than 1s.

2 when i use win2003 (sp1).   the activex call the web serivce fast less than 1s.

3 when i use win2003 (sp2).   the activex call the web serivce slow, test the same function will cost more than 3s.

4 when i use win2008. got the result same as 3.

Why ? Can anyone help me?

 

thank u all!
Chinese fairy tale

The Application is performaing very slow after upgrade to SQL Server 2008 x64

  

Hello All,

I am writing you all after I tried a lot of solutions to resolve my Issue, please find below my issue details..

Task: Upgrade from SQL Server 2000 Ent. Edition to SQL Server 2008 X64 for IA on windows server 2008 Clustered environment (Active\Active)

SQL Server 2008 Servers HW configuration:

  • 24 GB Of Ram
  • 2x Process or dual core
  • SAN storage
  • up to 1 Tera Storage

Looking for Client Query Analyzer (SQL Server 2008) or Equivalent Reporting Tools

  

I've recently upgraded from SQL Server 2000 to SQL Server 2008.  My accounting and marketing team is skilled and has been using SQL Query Analyzer for years to run smaller queries and build small Crystal Reports.  Unfortunately Query Analyzer is now bundled into the management studio.  That's a bit too much software for this level of power users.

Is there a client-side query analyzer for SQL Server 2008?  I'd rather use a Microsoft product than a 3rd party tool, but I suppose I could do that too.  Looking for something simple that will:

1.  Show users the database tables and/or views

2.  Run queries

Perhaps query analyzer isn't the way to go and my team needs a different reporting system.  If this is the way MS is heading, could you direct me towards a product or service that allows power users to get the information they need?  They will still need to look at raw data to build Crystal Reports though.


SQL SERVER 2008 TDE / Pass Private Key from Connecting Client

  

With TDE is it possible to pass the private key for an encrypted database from the client? 

I need to secure the database from the machine users.  They should only be able to access the database through my software, a C#/.Net app.  The server should only have the certificate and master key. 

 


Custom client app cannot connect to SQL server 2008

  

Hi,

We have a custom application developed using Access 2003 but converted to 2007 which connects to database SQL server 2008 converted from 2005. Users are unable to connect via application and get the following error.  Application uses ADO.NET to connect. But when Network library configuration and enable TCP/IP protocol with servername and portno using SQL Server Network Utility setup (cliconfg), It works fine. We have about 150 users but it is complicated to do for each users.

Also users uses windows authentication to connect. They belong to one of the three Windows Active Directory groups which are given RW permission on the database side.

'Connection Failed' error.

SQL State 01000

ODBC SQL Server Driver: ConnectionOpen(Connect())

Connection failed.

SQL State: '08001'

SQL Server Error: 17

[ODBC SQL Server Driver] [DBNETLIB] SQL Server does not exist or access denied.

 

------------------

connectionstring : "ODBC;DRIVER=SQL Server;SERVER=<<server>>;DATABASE=<<database>>;Trusted_Connection=Yes"

----------

 

Please help.

 

 


SQL Server 2008 R2 deploying any version of sharepoint results in extremly slow DB creation

  

Hello, When installing any version of Sharepoint(2007,2010) during the "Creating Configuration Database" Step it takes over 10 hours to complete.  Then creating a web app takes just as long. and the sites are extreemply slow. 

Environment:

1) DB Server - SQL Server 2008 R2 on Windows Server 2008 R2
2) Webserver - to host Sharepoint 2010 on Windows Server 2008 R2

The Servers are on the same network and running with lots of horsepower, disk and memory.  Are there any know issues with this and should we install Cummulative Update 3? Maybe that has a fix.  We exhausted all our options and need justification to apply the CU3 hotfix(s).

Thanks for your help.


2008 server Access database connecting win7 workstation with ODBC link works extremely slowly

  

I have an Access database on a 2008 server (64 bit), and notebooks with 32 bit win7. The program using the mdb is written in delphy, and running on my notebook, and working on data extremely slow. What can be the problem?

The database connector is an ODBC linked network drive.

On that same configured PC with XP it works normally.

Pappxla


SSIS package runs very slow on SQL 2008 R2 server, runs very quickly on virtual XP machine

  

Hi All,

I've been troubleshooting this issue on and off for a few weeks now.  I've scoured these forums and looked through sqlis.com, but I'm just about out of ideas.  Here's what's happening.

I have a *very* simple integration services package I developed on a  virtual Windows XP machine running on my workstation.  The package uses a script task to simulate a one-row source with four columns (int, char(64), varchar(512) and char(2)) and then passes that off to a fuzzy lookup.  The fuzzy lookup is running against a table of only about 6,000 rows.  The package then inserts the results into a table and exits.

When I run this from my virtual XP machine, it completes in 1-2 seconds.

When I execute this on the server (either as a job or through DTExec) it takes 14-18 seconds.  The server stores the package in MSDB and is also the location where the fuzzy lookup happens.

I've tried using the 32-bit runtime, creating 32- and 64-bit aliases to the server, changing the name of the server from the name to the IP address and port, stopping/restarting SQL Agent and SSIS Services... none of this seems to change the execution time.

The one thing I've found is that if I enable package logging on the logging tab of the job, using the SSIS Log Provider for SQL Server and pointing it to the same connection st

ODBC from Windows 7 client to SQL 2008 R2 server

  

I get an intermittent error when trying to connect to the SQL backend.  I am using the SQL Server Native Client 10.0 for my connection and it was created with no problems.  I am using it to access Dynamics GP 2010 data on the SQL backend.  SOMETIMES when logging into GP I will get a message (after about 5 minutes) stating that my login info could not be verified.  Other times I get in just fine.  When I try to troubleshoot this by "configuring" my DSN, I sometimes get stopped when trying to obtain default setting (or testing the connections) - other times it flies right thru without errors.  I am able to use the same ODBC connection (except that it is the SQL Native Client) from Windows 2008 servers, workstations running XP; but not reliably from my 32-bit Windows 7 machine. 

Any ideas?  Thanks in advance.

Hal Steinkopf.


What will happen with SSMS2005 and BIDS2005 after installing SQL Server 2008 client tools to a works

  

In 2009, after I installed VS 2008, then I installed SQL Server 2005 client tools.  The SQL Server 2005 client-tools setup installed a VS 2005 for my BIDS.  It seemed to me, with VS 2008 installed, installing SQL Server 2008 will install/add BIDS directly into the installed VS 2008.  Am I right? 

My questions are  – what will happen with our old SQL 2000/2005 databases and BIDS2005 packages if I install SQL 2008 client tools at the same workstation with the existing SQL 2005 client tools.  (Installing SSMS 2005
disabled SSEM 2000.) 

Thanks,
Jeffrey  


Linked Server on SQL 2008 is slow

  

Hi,

I have 2 MS SQL servers one with SQL 2008(machine A) and another with MS SQL 2005 (machine B)

I created a linked server from Machine A to Machine B. Executed a simple query

Select * from [Machine B].Database.Xtable

It took nearly 30 seconds to bring back 496 rows of data.

Similarly created a linked server from machine B to machine A.Executed the simple query

Select * from [Machine A].Database.Xtable

It took less than a second to display the same 496 rows.

Is there any specific setting to be done on MS SQL 2008 to improve the performance.

Any help is appreciated.

Thanks

Hari


Simple select on client very slow, fast on server

  

We copied a database from SQL Server 2005 to SQL Server 2008 R2 on a new server.

On the new server (24 cores, 24 gig memory) simple select statements from my client with SSMS that returns 10000 rows take about 50 seconds. The same query on the old server (1 core) takes less than 1 second. Directly on the new server the query runs very fast (also less than 1 second).

Execution Plans on both servers are exactly the same.

Client Statistics shows on the old machine under "Client processing time" 656 and on the new server 51018.

The same problem occurs on all other clients and with any other larger query/resultset.

It looks like a network issue. But the new server is located in the same datacenter and has a 1000Mbps network connection.

Any help is greatly appreciated.


Michael

Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend