Viewing 15 posts - 14,806 through 14,820 (of 49,552 total)
UncleBoris (1/14/2013)
Would READ_COMMITTED_SNAPSHOT be row versioning in SQL?
Yes. As is snapshot isolation.
I see their are a few articles about the possible overheads associated with this but is this something you...
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
January 14, 2013 at 1:55 pm
I don't know what your developers are smoking, but a SELECT most certainly can block an UPDATE or INSERT. Selects take shared locks. If it's doing a table scan, that's...
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
January 14, 2013 at 12:32 pm
ALTER DATABASE with the MOVE option will likely be easier. That changes the name in the system catalog, then you just take the DB offline, change the extensions in Windows...
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
January 14, 2013 at 12:27 pm
Just go over it a couple times, make sure you are getting minimal logging. I ran that particular test a number of times, as did a friend and, while we...
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
January 14, 2013 at 12:23 pm
Scaling out a SQL instance is not trivial. It's not a matter of adding a cluster and being done (and clustering's for HA, not performance). Multiple active SQL instances cannot...
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
January 14, 2013 at 9:26 am
Without all your code, I can't say. Maybe the operations weren't minimally logged (existing table, full recovery or any of the other reasons for not minimally logging)
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
January 14, 2013 at 8:59 am
Bhuvnesh (1/14/2013)
see the link http://jeffprom.wordpress.com/2008/08/22/fixing-torn-page-headers/
The solution he gave there is the absolute last resort for when there's no backup and checkDB can't repair the error. Furthermore, you should never detach...
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
January 14, 2013 at 3:11 am
jitendra.padhiyar (1/14/2013)
Moreover, its sql server 2000, what may be the solution ? Checkdb ?
Ideally, restore from a clean backup, but only once you know the severity of the problem.
Take 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
January 14, 2013 at 3:09 am
jitendra.padhiyar (1/14/2013)
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
January 14, 2013 at 3:08 am
There's a bug with missing index DMV where it recommends an index that already exists.
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
January 14, 2013 at 1:02 am
Don't use Task Manager to check SQL Server's memory usage. In many cases it will report a value far, far, far lower than what SQL is actually using. Use Perfmon...
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
January 13, 2013 at 12:59 pm
durai nagarajan (1/13/2013)
i have asked just to clear my confusion but is there any other work around?
If you mean to restore to a point in time earlier than any full...
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
January 13, 2013 at 12:57 pm
That would work better than the order you originally had, yes.
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
January 13, 2013 at 12:54 pm
How do you expect to restore to a point before that of the full backup that you're using?
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
January 13, 2013 at 9:39 am
Vedran Kesegic (1/13/2013)
But, it turns out that checkpoint indeed occurs even at the beginning of a log backup, not just full/diff backup.
It can occur. It's not an automatic thing 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
January 13, 2013 at 9:38 am
Viewing 15 posts - 14,806 through 14,820 (of 49,552 total)