View Complete Post
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 am running a query in which there is a primary key
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 a class that being used to connect with the DB. Now I want to count how many times each web request executes the queries, but I've no idea where to store the counted value. I mean, Session wont, ViewState wont work as site also have webservices. What else I can use ?