Viewing 15 posts - 11,131 through 11,145 (of 49,552 total)
IgorMi (10/31/2013)
If an escalation occurs then, it'll switch from ROW to TABLE lock, skipping the intermediate PAGE level which is currently OFF. You'd better have PAGE level set to ON.
Escalation...
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 31, 2013 at 5:55 am
SQLSteve (10/31/2013)
So you would advise to turn Row Locking off?
I wouldn't recommend that, not without a very good reason (of which to be honest there aren't many)
Default has 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
October 31, 2013 at 5:52 am
tony28 (10/30/2013)
GilaMonster (10/30/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
October 31, 2013 at 1:40 am
If you keep maxdop at 0, then there can be as many active threads for each query as you have cores. If you put maxdop to 4, then each 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
October 31, 2013 at 1:32 am
Just 1 \ and an n will do it. How do you escape things? I tried a few random things and didn't work. Can't the software do 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
October 31, 2013 at 1:31 am
Then they'll be the same.
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 30, 2013 at 3:55 pm
4 processors or 4 cores?
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 30, 2013 at 3:46 pm
Ask yourself, which is preferable, a corrupt database that you know is corrupt or a corrupt database that you don't know is corrupt.
CheckDB when run without a repair option (which...
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 30, 2013 at 3:44 pm
In short, no. You would have needed to have a trace or an extended events session running at the time.
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 30, 2013 at 3:43 pm
A restore recreates a database exactly as it was at the time of the backup.
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 30, 2013 at 1:04 pm
bbsr (10/30/2013)
so on both installation I would have to create named instances - servername\sql2008named_Instance and servername\sql2012_namedInstance and I cannot have a default instance on any of them?
One of them can...
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 30, 2013 at 9:32 am
You can't install two default instances. If you install 2008 as the default instance then 2012 will have to be a named instance. You can install both as named instances....
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 30, 2013 at 9:31 am
I remember seeing a CV where someone had rated himself 10/10 on 4 versions of Windows (XP, 2000, 98, NT4), two versions of SQL Server (2000, 2005) and a version...
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 30, 2013 at 8:29 am
tony28 (10/30/2013)
Like I said, I didnt see yet problem with no lock ...
Doesn't mean it didn't happen. If you have locking problems, consider one of the snapshot isolation levels....
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 30, 2013 at 8:23 am
Task manager is limited, it doesn't show memory allocated with the AWE API (which is used when you have locked pages enabled)
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 30, 2013 at 7:58 am
Viewing 15 posts - 11,131 through 11,145 (of 49,552 total)