Viewing 15 posts - 91 through 105 (of 205 total)
Sorry about the duplicate post but when I first submitted the question I was met with a 500 error and lots of useful info about IPs,Paths,table names etc that I...
July 10, 2009 at 8:25 am
Thanks for that, it is useful but it looks like I would have to check each plan in turn to find out whether it caused the lookup. I was hoping...
June 22, 2009 at 10:11 am
An old version of the site was written that way however we moved all CUD to procs for security reasons as it meant we didn't have to grant write access...
June 11, 2009 at 8:41 am
The server is a dedicted server with just this system running on it.
The biggest SITE_JOBS_INDEX table has 2299 rows, the biggest SITE_CATEGORY_MATRIX 119,000.
I have a job that monitors blocked processes...
June 11, 2009 at 5:16 am
The page in question loads fast and runs okay 98% of the time. The query is indexed correctly and I am looking into the query plans. The problem only occurs...
June 10, 2009 at 12:55 pm
Also another aside going back to the difference between SIMPLE and FORCED. I set the DB to SIMPLE mode and then ran a couple of very simple queries where the...
June 9, 2009 at 3:53 pm
Just to let you know that it is possible to set the DB to simple mode and run that particular query as forced using a plan guide.
I just ran a...
June 9, 2009 at 3:33 pm
Yes its an adHoc query on an old site ASP classic! being passed to an SQL 2005 DB.
The system in general runs very well and handles quarter million hits a...
June 9, 2009 at 9:15 am
Well I've been testing on our dev box to ensure that its worth doing and that we currently aren't benefiting from cached plan re-use for this particular page/query and it...
June 9, 2009 at 9:02 am
Yes running the same query from different browser instances (IE and FF3) with different param values and the same plan is shared.
Looking at the differences between columns in the output...
June 9, 2009 at 8:42 am
Yes you are right it was due to the same values being submitted. I changed the values between calls and it causes new plans. The value of objType = AdHoc...
June 9, 2009 at 8:27 am
The problem was that the dbid column was returing NULL values so the result I was looking for was not being returned. I modified the query to
SELECTtext,*
FROMsys.dm_exec_query_stats qs
CROSS APPLY sys.dm_exec_sql_text(qs.sql_handle)...
June 9, 2009 at 6:41 am
I've read the BOL and the site in question does seem suitable as the main page getting hit is using a static SQL string thats being executed and none of...
June 8, 2009 at 8:49 am
rafidheenm
notice in my post I said "I used to" as in
"I used to use lots of CASE statements and IF branches to handle queries that needed to be dynamic but...
June 2, 2009 at 6:59 am
Yes that link is a very good article that covers all the various methods and a good discussion of recompilation. As per my first example I used to write my...
June 1, 2009 at 6:46 am
Viewing 15 posts - 91 through 105 (of 205 total)