View Complete Post
We have a monitoring tool set to check to see if the home pages for our 3 web apps load in under 60 seconds every 10 minutes. All 3 web apps load in under 3 seconds on every 10 minute check except for one exception. One check every
day one of the web app's home page takes longer than 60 seconds to load. This happens at 11:45PM when there is very little user usage on the environment. The characteristics of this page are as follows: The only thing on
the page is a list view web part which was added by the browser. The page has not been customized with SPD or code at all. The list that it pulls is a simple links list that has 281 items on it. The view
pulls all 281 items and displays them in sets of 100. I cannot find any associated event in the server events and/or SharePoint ULS logs nor are there any daily sharepoint timer jobs running at that time. Our full index happens
at midnight with incremental happening hourly. Our enviroment is 2 WFEs, 1 App/indexer and we have a separate SQL cluster backend.
Could someone lead me possibly in the direction I should take next in my troubleshooting?
I have an OLE DB source in a data flow task. The connection is pointing to a SQL Server 2008 instance. My SQL works fine when I click the preview button. Now I need to make it parameterized by adding a question mark in my where clause.
After doing so & clicking the Parameters button, I get the error described in
this post . When I try to do what's described therein to correct the problem (click the "build query" button), I get the error "The PIVOT SQL construct or statement
is not supported."
I can't make this query an expression; it's simply too complex to maintain that way (besides, just pasting it into an expression builder window and trying to evaluate
as is doesn't work - can't evaluate).
So the question is, how do I parameterize a query? And why does SQL here work so radically differently from SQL in an execute SQL task?
I'm building a report in Crystal Reports using a SQL command against a T-SQL 2005 telephony database.
I need to be able to run the query across a given datetime range, 6 months for example and bring back a 5 day display (Mon-Fri) with a group for every 15 minute interval in each day.
The group figures need to contain an average of the amount of calls presented for each 15 minute interval on any day across the whole datetime range, so for example the Monday 10:00 - 10:15 figure would be an average of all calls presented in every 10:00-10:15
range on each of the Mondays that fall within the datetime range.
I've got a query built now that gives total presented figures grouped by these intervals across one week but I can't figure out how to do this average function across a range.
Does anyone have any idea how I'd go about accomplishing this? I'm pretty new to SQL but keen to learn so any pointers on functions to research etc would be very much appreciated.
Thanks alot in advance, Andy.
Query for detail view across one week included below for table/fields etc...
count(DISTINCT Calls.SessionID) as Presented, min(Calls.startDateTime) as DateTime
INNER JOIN QueueDetail
ON Calls.sessionID = Queues.sessionID
AND Calls.sessionSeqNum = QueueDet
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?
I have a need to create an applicaiton that can be installed 1 time only be a user. The user may or may not be and administrator.
How can I do this (without registry alteration if possible)?
I have a need to create an applicaiton that can be installed 1 time only be a user. The application can also be used only 1 time. (on a given PC)
The user may or may not be and administrator.
By any chance, can we optimize the below query..This is running for 2 hrs..As of now, i really don't have any execution plans. If i replace "IN" with "Exists", i am saving few minutes. Can someone please optimize the query little more?
pm.site_id in ('ALF','BRF', 'COF','CUF','GAF','JOF','JSF','KIF','SHF','WCF',