Viewing 15 posts - 45,856 through 45,870 (of 49,552 total)
I spoke with the South African MVP lead back in March on this topic. He said that in his opinion (not an official MS statement) the most important quality is...
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
July 8, 2008 at 11:54 pm
Try this.
DECLARE @TheDate DATETIME
SET @TheDate = '1994-08-01 00:13:00.000'
select dateadd(dd, datediff(dd,0, @TheDate),0)
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
July 8, 2008 at 12:38 pm
Is it consistent? Did the data have to be fetched from disk on one? Possible blocking?
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
July 8, 2008 at 10:59 am
What I suspect is happening is that the cluster service notices that SQL is not responding (IsAlive Check) when SQL hits memory problems and forces a fail-over to the other...
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
July 8, 2008 at 10:43 am
Graham (7/8/2008)
Thanks for your reply, i appreciate it, will get back to this thread tomorrow when the office is open.
Yes i saw the full scans are pretty high, does...
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
July 8, 2008 at 10:34 am
sqlservercenter (7/8/2008)
maybe you could consider to shrinke it first,then reindex or reorgnize is ok.
Don't! Shrink! Your! Databases!
tucankur: Have you checked for hardware errors? Reoccuring corruption can indicate a storage...
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
July 8, 2008 at 10:26 am
Suresh B. (7/8/2008)
Is it possible to have 0 deadlocks in a busy multiuer system?Is it normal to have around 10 deadlocks daily?
It is not normal to have 10 deadlocks a...
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
July 8, 2008 at 10:14 am
Mani Singh (7/8/2008)
Here the STEPS you should perform.Kill destination connections. (run multiple times)
set Db in single_user mode.
Or just set the database into single user mode with rollback_immediate
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
July 8, 2008 at 10:12 am
Mani Singh (7/8/2008)
if you see a deadlock that is in place for a long time, make sure, it is not running a HUGE Query.. then kill the SPID associated with...
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
July 8, 2008 at 10:11 am
And you see the one from reporting services with duration = 60 sec?
Can you perhaps post the query?
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
July 8, 2008 at 7:54 am
Index placement depends on what queries you have running and what your data distribution looks like. To put it very simply, you create indexes to support queries that you 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
July 8, 2008 at 7:39 am
Firstly, you're on 32 bit. Unless you have AWE enabled and the /pae switch in boot.ini, SQL can only use 2 GB max. that would explain why so little memory...
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
July 8, 2008 at 7:30 am
Jeff Moden (7/8/2008)
Based on what I've seen in real life at work...5% Newbie
60% casual knowledge
10% good knowledge
5% DBA quality
5% Developer quality
5% Hybrid quality
10% Stupid or dangerous or both
I'd probably scale...
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
July 8, 2008 at 6:03 am
Grant Fritchey (7/8/2008)
GilaMonster (7/8/2008)
"We fixed it. No thanks to you."I can't honestly say that I wouldn't have hit the guy. Nice exercise in restraint.
I very nearly put the pizza 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
July 8, 2008 at 5:38 am
Mark Horninger (7/8/2008)
Jeff,Was it a test DB with space issues? Dunno why anyone would want do do that....
Mark
I think it was a posting on these forums. Stick...
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
July 8, 2008 at 5:11 am
Viewing 15 posts - 45,856 through 45,870 (of 49,552 total)