Viewing 15 posts - 46,126 through 46,140 (of 49,552 total)
You'll have to test each way and see what's better. Without a lot more info, there's no way to say which will be faster in your case.
There is a massive...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2008 at 11:53 pm
coatta (6/22/2008)
So, is there a way on a production server to capture things like the deadlock graph without the Profiler running?
Sure. Switch traceflag 1222 on and all deadlock graphs (in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2008 at 11:43 pm
onlo (6/22/2008)
I am doing some bench mark on SQL Server, I would like to ask you 2 questions :
(1)I want to erase all the cache content (cold buffer cache)...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2008 at 11:42 pm
Why do you need the proc turned into a view?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2008 at 12:29 pm
Bilal (6/22/2008)
I expect about 1000 rows to return , and their is one type of index defined which is traffic1each table have millions of records
any thing else ?
Yup....
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2008 at 12:26 pm
What's the table's schema? What indexes are defined on it? How many rows are in the table? How many rows do you expect your query to return?
Do you absolutely need...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 22, 2008 at 5:37 am
jvamvas (6/20/2008)
Also consider 1)changing recovery model2)use TABLOCK
What????
Do the two queries in question need to be SELECT *?
Have you checked the execution plans of the select queries to ensure that...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2008 at 10:27 am
Depends on the data, depends on the table structure, depends on the query.
It's not a question that can be answered in isolation.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2008 at 9:59 am
mithun gite (6/20/2008)
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 21, 2008 at 9:49 am
GSquared (6/20/2008)
Truth be told, I'm going by something I read a while back, and haven't tested it myself....So ... give me a few minutes here. 🙂
Are you maybe thinking about...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:49 pm
Line 117 points at this update:
update #programs
set programid = programid
from #tmpProgMapping
where LOWER(TaskPrefix) = LOWER(Prefix)
It's probably supposed to be this
update #programs
set #programs.programid = #tmpProgMapping.programid
from #tmpProgMapping
where LOWER(#programs.TaskPrefix) = LOWER(#tmpProgMapping.Prefix)
Oh, as...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 12:44 pm
mithun gite (6/20/2008)
would it this immidiate change will benefit me a bit or not ?
No. They're still on the same physical drive. c, d and e are just logical...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 7:28 am
I'll check it on monday.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 7:23 am
Are you sure they're from IIS?
If you check the slow running queries in sysprocesses, what is the wait type that's listed for them?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 7:23 am
As was pointed out to me the other day (after I said the same thing in the same situation), data types are checked before the instead of trigger fires, in...
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
June 20, 2008 at 5:48 am
Viewing 15 posts - 46,126 through 46,140 (of 49,552 total)