Viewing 15 posts - 43,531 through 43,545 (of 49,552 total)
bhuvnesh.dogra (10/27/2008)
Actually creating/droping is for spped up the insertion
Does it speed up the insert? Have you tested with and without the index recreation and proven that it's faster...
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
October 27, 2008 at 7:54 am
Now things become a little clearer. Is the query you posted taking 21 seconds or is the entire stored procedure (with the inserts and all the index creations) taking 21...
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
October 27, 2008 at 6:07 am
It could be due to a database/log restore. (Is this a logshipping destination?). It could be from certain configuration changes (sp_configure). It could be from someone running DBCC FREEPROCCACHE. It...
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
October 27, 2008 at 5:50 am
Jonathan Kehayias (10/27/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
October 27, 2008 at 5:46 am
The first thing you should do is make sure that all tables have primary keys and are properly normalised.
Run profiler for a while during your busy times. Record the rpc:completed...
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
October 27, 2008 at 5:08 am
Leo (10/27/2008)
Hi Gila,Okay, I have untick the box for auto repair option. So do you think one of the Master,MSDB,TempDB got a error? It was failed becasue of that?
Maybe
Shall I...
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
October 27, 2008 at 4:41 am
bhuvnesh.dogra (10/27/2008)
yes u are rightthis is the IO results
--------------------------------------------------------------
SQL Server Execution Times:
CPU time = 0 ms, elapsed time = 7 ms.
--------------------------------------------------------------
The entire result please....
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
October 27, 2008 at 4:40 am
You should never run repair on a regular basis. It should only be run when there is corruption, and there's no other way to fix it. It's a last resort,...
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
October 27, 2008 at 4:07 am
bhuvnesh.dogra (10/27/2008)
but rest os the tables are not actually tables they are table views;tables which are from other databases to main database ...
What are the view definitions? What indexes are...
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
October 27, 2008 at 3:58 am
Great. Please can you post table definition and index definitions.
How many rows are in the tables? How many does the query return? How long does the query run?
The plan looks...
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
October 27, 2008 at 3:19 am
Run the query with the execution plan option on.
Right click the generated plan and select save. Save it as a .SQLPlan file (You are using SQL 2005? I assume so...
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
October 27, 2008 at 2:40 am
patricklambin (10/27/2008)
( maybe with new features coming from the 2008 version, i can dream)
If they did that, what incentive would you have to get SQL 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
October 27, 2008 at 2:22 am
What were the full results of the CheckDB that listed the errors?
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
October 27, 2008 at 2:19 am
Is it still happening?
What login are the maintenance plans running as? What rights does that login have?
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
October 27, 2008 at 2:18 am
IsNumeric returns true if the value passed to it can be successfully converted into any one of the numeric datatypes.
3D2 and 3E2 can be cast to float (and mean 300),...
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
October 27, 2008 at 2:17 am
Viewing 15 posts - 43,531 through 43,545 (of 49,552 total)