Viewing 15 posts - 61 through 75 (of 99 total)
I do have similar problem with complex SQL within SP. Did you check when this problem occured, is your execution plan same as when it behave ? I had discussed...
May 14, 2004 at 1:15 pm
I'm not clear what kind of error are you getting. Is there any line been logged to the SQL errorlog ? Who owns the SQL services ? Is that ID...
May 11, 2004 at 7:09 am
I don't know anyway to definite identify the Application lock. But, I normally select from sysprocesses table and pay special attention to 'waittype' column. When the value in this column...
May 11, 2004 at 7:04 am
Do you try 'keep plan' option within your SP. I had some simliar problem, somehow the same SP after running a while, it start using the wrong plan.
Second, since...
May 6, 2004 at 7:11 am
What's the top 10 slowest SQL statement, did you run a execute plan to see how this SQL really work. Are all the columns on the where clause have proper...
April 23, 2004 at 9:41 am
Few things you should look into
1. Your cache hit ratio
2. Index fragmentation (when is the last time you re-index the DB ?)
3. statistics (when is the last time you run??)
More...
April 23, 2004 at 9:18 am
Nope, it is local. I also try copy the whole CD to the local C: to do the install. Same problem.
April 14, 2004 at 10:29 am
My experience tell me when temp table created/dropped on the fly. The sysindexes and others... statistics did not get update accordingly. Query plan may still using the wrong statiscs, which...
April 13, 2004 at 10:41 am
Is your APP using Global temp table or local temp table ? My experience sometime Global temp table may yield a lot better performance.
April 13, 2004 at 10:01 am
latching may can alleviate by re-org your cluster index.When is last time you drop/recreate your cluster index.
April 13, 2004 at 9:44 am
It is brand new server has C: 8GB, D: 144 GB and E: 144 GB. Only O/S is on. I do not believe there is any space, special characters on...
April 13, 2004 at 7:31 am
tempDB contention may can alleviate by setting flag -T1118 with mutiple file for the tempdb. I had the same problem and was alleviate by adopting the change. You may still...
April 13, 2004 at 6:34 am
Does both servers run same level of MDAC (if you are using OLE DB provider) ? I had same problem, but after sync-up MDAC problem went away.
March 31, 2004 at 6:22 am
Thanks for the first one. Though, I don't think 'SA' permission is required on SQL 7.0
For second one, if I only assign 4 cpu to each instance why I...
March 29, 2004 at 11:49 am
Viewing 15 posts - 61 through 75 (of 99 total)