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


Post New Web Links

improve sql execution time

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :Sql Server
 
i need to select one of the record out of 10 thourands record,but when the program execute the sql , it takes a long time to extract data and my PC indicate low memory alert.   how can i improve the execution time to select the data from sybase


View Complete Post


More Related Resource Links

Get Query execution time

  
I need to find out the query execution time from the front end .Where should I insert the code for that.Please help.. I am using the bleow query: OracleConnection con = new OracleConnection(ConnStr); con.Open();  OracleCommand cmd = new OracleCommand("Stored_Proc",con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add(); .................... ................ OracleDataAdapter oda = new OracleDataAdapter (cmd);  

How to do Time bound workflow execution

  
The requirement is that the workflow should complete in a time specified as a workflow parameter, if it is not able to execute all the activities , it should terminate itself. Can anybody give me an idea how i can do that. regards

Execution Time changes in a fashion

  

Hi All,

Here is my problem,

I have an sp to retrieve max 1000 records(from joining 6 diff tables & conditions too). 

suddenly a bulk amount (millions)of records inserted to the tables.

Here is the statistics of the sp executed in an order :[any way result will be top 1000]

0 seconds for querying a dept of 10500 records without extra parameters.

0 seconds for querying a dept of 10500 records with extra parameters.

4 seconds for querying a dept of 700500 records without extra parameters.

8 seconds for querying a dept of 700500 records with extra parameters.

now the problem starts

3 minutes for querying a dept of 700500 records without extra parameters.[which previously executed in 4 seconds.]

Thanks for looking into this,

Any solution/suggestion will help me to recover from mental stress :(

 


Query execution time from 1 second in SQL 2000 to 20 Seconds in SQL 2008 R2

  

When I ran this query from SQL 2000 it takes 1 second. now in SQL 2008 R2  the same query is 20 times slower.

This is the query and the numer of records and the time in SQL 2008 R2:

SELECT * FROM dbo.CxP_Saldos 
0 seconds, 923 Rows
SELECT * FROM S_Conta.Cuentas
0 seconds, 662 Rows
SELECT * FROM S_Conta.Cuentas c INNER JOIN dbo.CxP_Saldos s ON c.id = s.CtaProv
18 seconds, 923 Rows

how can I submit the actual execution Plan?


Report Execution Time Out/Delayed

  

I have a report i have developed in Bids sourcing from AS cube. Whe I execute the report inside BIDS, i get the results within couple of seconds. But when i run the same report from Report Manager Site, It process for a long time and then generate the following error. Any ideas gues?

An error occurred during client rendering. An error has occurred during report processing. An error occurred within the report server database. This may be due to a connection failure, timeout or low disk condition within the database.Timeout expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

Thanks


Nested Views execution time, how long does it take to "unpack" the SQL?

  

We have the case where in a reporting solution for an application it was decided to build a series of reporting views, fair enough. These views are layered, nested several levels deep at times and, not unexpectedly, as our customer's data grows so these views slow...

To complicate matters further, the report SQL may then join several of these top level reporting views to produce the data it needs.

In a recent support request for a slow performing report we ripped the sql out of the report, pasted it into SSMS and while investigating found a join error in the reports SQL that took execution time from ~ 2 minutes down to about 6 seconds...  Regardless of what we did after that we were unable to reduce the time below 6 seconds using our reporting views. Rewriting the SQL against our base tables takes a fraction of a second to return the needed information.

What I need to do is demonstrate where the extra time in getting the results from the views is spent.  My guess is that it is in untangling all the views and then ending up with a less than optimal query plan. Is there anyway to measure how long it takes the server to "unpack" the nested views into a single SQL statement before it can be executed? Knowing how much of the 6 seconds this is accounting for would be helpful to us in our decision making process.

Thanks,

Bi

Decrease Query execution time

  
Hello friends,
I am facing problem since last 5-6 month in sql server in query executing it takes 10-12 mins to execute even if database is on local pc.
I want to decrease it and want to make it execte withing 30-40 sec..
It is getting data of whole month with subquery of 1-30 date and each joining 3-5 tables for 300-500 persons.
so any ideas....
Confused D'Oh! 
One thing that i can do some process in background and insert fetched data to the some other table and at the time of executing above query fetch data from that table.
if its possible then how can i do it?Is there any other way to solve this problem?

Thanks in advance.. Smile 
RAHUL PATEL

sql server maintenance plan schedule time and execution time difference

  

Hi All,

One of my customer db there is one maintenance plan(full backup / Transaction log backup  ) schedule time for the full backup is 11:00:00 PM daily and for transaction log backup 12.30 pm Sunday to Friday ,I checked the job created by maintenance plan there also schedule time is same but when i check the history of the job it shows it happened at 7:00:00 pm every day. why there is time difference ?

Product version is 8.00.2055(SP4)

i checked the MSDB.dbo.sysjobschedules table and the next_run_date is not updated properly,it is showing yesterday 11:00:00 pm

 

please help me to resolve this issue

Thanks 

 

 


SQL Server 2008 query execution time is different if i execute it in management studio or from code

  
When I execute query from software which i wrote in c# it required lots of time to complete but if I execute exactly the same query from management studio it will be done in seconds. In both cases execution plan is the same. 

Stored Procedure taking time in execution

  

Dear All,

 

I am breaking my head on this issue since long. I have stored procedure in MS SQl and when I try to execute that procedure by providing all the parameters in SQL Query, it takes long time to execute but when I try to directly run the query which is there in SP it executes in no time. This is affecting my application performance also as we are using stored procedures to fetch the data from DB Server.

Please help.

Regards,

Vikram


Vikram

Stored Procedure taking time in execution

  

Dear All,

 

I am breaking my head on this issue since long. I have stored procedure in MS SQl and when I try to execute that procedure by providing all the parameters in SQL Query, it takes long time to execute but when I try to directly run the query which is there in SP it executes in no time. This is affecting my application performance also as we are using stored procedures to fetch the data from DB Server.

Please help.

Regards,

Vikram


Vikram

Asynchronous update of page immediately after load to improve response time

  
The article Asynchronous update of page immediately after load to improve response time was added by kaushalendrarai on Monday, March 14, 2011.

Response time is one of major factor in deciding the performance of web application. Many time we come across pages where content of page can be updated asynchronously immediatly after the page rendering in responce to page request. We can achive this

SQL Query execution time difference

  

SQLSERVER: 2005

I am running a query in which there is a primary key Mail_Id

SELECT  TOP 1000 Mail_Id, MailUID,FromAddress,ToAddress,CcAddress,Subject,SentDate FROM MailIdSystem

where Subject LIKE '%hi%'

ORDER

Round off time to the nearest minute

  
How would you round this up to the nearest minute? There isn't a built in function to do this so you have to use a little bit of maths to get there. There are 60 seconds in a minute. We already have 38 seconds on the clock. So we need to add on 60 - 38 = 22 more seconds.
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