Viewing 15 posts - 42,271 through 42,285 (of 49,552 total)
rew (12/18/2008)
Hi AllWhen I do "Index REBUILDs", my database files GROW. Alot! And the database is in "SIMPLE" recovery mode.
Yup. They will. Rebuilds are logged operations (though bulk logged 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
December 18, 2008 at 11:04 am
r.hensbergen (12/18/2008)
Oh no, my ancestors went to your country and.... We're family! 😉
Hehehe :hehe:
Actually I'm originally from the UK, so you don't have to worry. :w00t:
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
December 18, 2008 at 11:00 am
srawant (12/18/2008)
Gail will If I turn on that flag will it show me the graph of the past like it was occurred yesterday...
No. It will print the deadlock graph...
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
December 18, 2008 at 10:38 am
Steve Jones - Editor (12/18/2008)
Well, this is officially the longest thread on the site.
We win! :hehe:
r.hensbergen (12/18/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
December 18, 2008 at 10:36 am
You posted the second question only 3 hours ago (and the 1st question only 12 hours ago). This isn't a chat room. Be patient. If you need help urgently, contact...
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
December 18, 2008 at 10:17 am
You can enable traceflag 1222 (DBCC TRACEON (1222,-1)) to get the full deadlock graph written into the error log. That will tell you what the other process was.
As for the...
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
December 18, 2008 at 10:14 am
Ok.
Is there a question?
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
December 18, 2008 at 8:32 am
Chris Morris (12/18/2008)
.. the global temp table is available outside the scope of the dynamic sql.
Ah. I thought that the end of the dynamic SQL would mean that the last...
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
December 18, 2008 at 8:12 am
Jeff Moden (12/18/2008)
It's bad enough that we now have two national languages
Only 2? Be grateful, I've got 11. Only two of those are due to immigration (and both...
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
December 18, 2008 at 7:54 am
Ok, so you're implementing application load balancing, completely outside of SQL and DB mirroring for high availability.
What's the question then? I think I've missed something.
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
December 18, 2008 at 7:24 am
It'll be recorded in the default trace. There are 5 (or so) trace files in the SQL error log directory, that's the default trace (providing you haven't turned it off)
The...
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
December 18, 2008 at 7:12 am
clementhuge (12/18/2008)
However, by load balancing with several servers and let the round-robin clustering done by the application, I should achive load balancing, no?
How are you replicating the changes from one...
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
December 18, 2008 at 7:09 am
Grant Fritchey (12/18/2008)
I mean, did you ever see this before:
I have.
Great. Something else to worry about.
Not anymore.
Also, from that KB that you posted
Note In SQL Server 2005 Service Pack 3...
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
December 18, 2008 at 7:02 am
clementhuge (12/18/2008)
I would like to develop a high availability strategy for a company (both automatic failover and load balancing)
If I well understood clustering, it allows you to have n nodes...
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
December 18, 2008 at 6:50 am
Jack Corbett (12/18/2008)
The answer is "Yes"
I thought it was 42.
Tramp, can you state your question a little more clearly please? The question title gets cut off.
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
December 18, 2008 at 6:46 am
Viewing 15 posts - 42,271 through 42,285 (of 49,552 total)