RE: Query performance

Hi Phil,

Thank you for using MSDN Managed Newsgroup Support.

I understand that you want to know why in SQL Profiler, your .Net
Application is reads more Data Page than using the same query in Management
Studio. If I misunderstood your concern, please feel free to let me know.

Performance Issue can be related to a lot of things.

Do you use index on the tables you are querying?

Also, would you please try to view the Execution Plan in the Management
Studio to see the detail Execution steps.

Basicly, .Net SQL provider will use the ADO.NET to connect to the SQL
Server 2005. I have tested on my side for some .Net Applications and using
the same query in Management Studio. They accessed the same data pages.

Performance issues can be difficult to troubleshoot and resolve in a
newsgroup setting due to the number of variables and the amount of time
required to narrow down possible causes and observe the effects. We will
assist as best as we can, but you may wish to consider contacting CSS for a
more timely resolution for these type issues.

To obtain the phone numbers for specific technology request please take a
look at the web site listed below.
http://support.microsoft.com/default.aspx?scid=fh;EN-US;PHONENUMBERS

If you are outside the US please see http://support.microsoft.com
for regional support phone numbers.


Thank you for your patience and understanding.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

.

Relevant Pages

  • RE: Moving SQL 2000 Database to SQL 2005
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... from SQL 2000 to SQL 2005. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.server)
  • Re: sqlx2008 basic configuration task
    ... In response to the second question, this is just one pc, with one instanse of SQL Express 2008, installed locally, on one domain. ... Thank you for using Microsoft MSDN Managed Newsgroup. ... Microsoft Online Community Support ... a Microsoft Support Engineer within 2 business day is acceptable. ...
    (microsoft.public.sqlserver.setup)
  • RE: Cannot telnet to server from LAN
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... we could get the port number of the sql instance by SQL Server ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.connect)
  • Re: Creating a database on a local Sql Server Express
    ... It is using the Sql Server ADO.NET ... Thank you for using Microsoft MSDN Managed Newsgroup. ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)
  • RE: Creating a database on a local Sql Server Express
    ... Thank you for using Microsoft MSDN Managed Newsgroup. ... we can use Sql Server Management Studio to ... Microsoft Online Community Support ...
    (microsoft.public.sqlserver.setup)