Why the Same sql query taking much more time in other server.

Hi all

I have Database size 12GB in SQL Server 2005 and It is backed up.

Now I tring to restore Database in SQL Server 2008 R2(wizard)....it is not at complted after 2hours...still running.

any idea..or help appreciated..

Hi,

I have an MDX query which runs fine in the MDX Sample Application. It runs against an SSAS 2000 cube. In my query there is a recursion kind of a logic. It takes about 1-2 sec to run in the MDX Sample Application. My sample application is in the same server as my AS 2000 cube is. However when I run the same MDX from another server through BIDS (2008) it takes an unusually long amount of time to run. Most of the time it times out. :(

As a workaround I created 4 calculated members in my Cube itself (Initially these were used as members in my MDX). I thought that maybe the recursion logic is the culprit so I modified my MDX, removed the recursion part. But still from my SSRS it is taking a long time.

Any pointers to where I am missing the trick ?

Thanks in advance,

Suman

Hi All,
SQL Query is taking long time to run in my report. It is using Clustered index seek when I am querying for 2 days on invoice_itemized table. It is returning 99 thousand records. It is returning  2524094 records and it is using clustered index scan when I am querying for one month. For one month It is taking 7 minutes.
Basically it is not using the index defined for the store_Id, status and datetime columns in the invoice_totals table. Can I force the sql query to use the specified index?

Please suggest me to improve the performance....

SQL Query
=========

SELECT
Invoice_Totals.Store_Id
,Invoice_Totals.DateTime InvoiceDate
,Invoice_Totals.Invoice_Number
,Invoice_Totals.CustNum
,Invoice_Totals.Cashier_Id
,Invoice_Itemized.ItemNum
,Invoice_Itemized.DiffItemName
,Invoice_Itemized.Quantity
,Invoice_Itemized.origPricePer
,Invoice_Itemized.PricePer
,Invoice_Totals.Discount InvDiscPercent
,Invoice_Itemized.LineDisc LineDiscPercent
,CASE
WHEN Invoice_Totals.Total_Price <> 0 AND Inventory.ItemType=7 AND Invoice_Totals.Discount = 0 THEN ((Invoice_Itemized.PricePer * Invoice_Itemized.Quantity) * -1) / ((Invoice_Totals.Total_Price) + ((Invoice_Itemized.PricePer * Invoice_Itemized.Quantity) * -1))
WHEN Invoice_Totals.Total_Price <> 0 AND Inventory.ItemType=7 THEN ((Invoice_Itemized.PricePer * I

Hi All,

I have  created report based on below mention MDX query ,but it will take more time say of 10 mins to execute.while other report having bulky data in their datset working fine.

Kindly suggest how do i optimise the Query so it will take less time

with

member [measures].[A]as
iif([Measures].[CALLSHANDLED]=0,0,[Measures].[HANDLETIME]/[Measures].[CALLSHANDLED])

member [measures].[B]as
iif([Measures].[Avg After Call Work]=0,0,[Measures].[Avg After Call Work])

member [measures].[C]as
iif([Measures].[Staff Time]=0,0,[Measures].[CALLSHANDLED]/[Measures].[Staff Time])

member [measures].[AA] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[A] )
member [measures].[BB] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[B] )
member [measures].[CC] as ((STRTOMEMBER(@EmployeeEMPLOYEENAME)), [Measures].[C] )

 member [measures].[Rank_Avg_Handle]as
(filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members,
iif([Measures].[CALLSHANDLED]=0,0,
[Measures].[HANDLETIME]/[Measures].[CALLSHANDLED])>[measures].[AA]).count)

 member [measures].[Rank_Aft_Avg_Call]as
(filter ([Employee].[EMPLOYEE NAME].[EMPLOYEE NAME].members,
iif([Measures].[Avg After Call Work]=0,0,[Measures].[Avg After Call Work])>[measures].[

Hi all

I have event table where I need to select records between days. my statements look like

Select 
  Event_ID
  ,Event_Type
  ,Event_Time
From 
  Event_Table
Where 
  CONVERT(char(8),Event_Table.Event_time,112) BETWEEN 'request start date' AND 'request end date'

Now everything look fine except from if I need the statement to request the date between as Date_start and Date_End any time it run. The idea is to request a for start and end period of date any time the scrpt run. the script will be run as DOS batch file. 

In my last column, I discussed Microsoft® Application Center Test and how it could be used to measure the performance of your Web application (see Extreme ASP. NET: Tools of the Trade: Application Center Test).

Rob Howard

MSDN Magazine August 2005