Viewing 15 posts - 3,586 through 3,600 (of 49,552 total)
ramana3327 (2/15/2016)
If you are not using enterprise edition, I think it would be ok with rebuild indexes weekly using maintenance plans
Don't use maintenance plans for index rebuilds, no matter what...
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
February 16, 2016 at 2:47 am
sh856531 (2/16/2016)
Would SQL Server detect that the user aborted?
No, because it's not the user that's requesting the data, it's the web server. SQL will finish the web server's request. If...
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
February 16, 2016 at 2:31 am
Hugo Kornelis (2/16/2016)
Oh, I am not laughing. Not at all. I am concerned and bewildered. Mostly concerned.
Likewise. With a side of terrified that one of the buffoons might actually get...
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
February 16, 2016 at 2:23 am
If you ran this kind of setup, the query in the second window would be blocked forever (or until someone closed the connection for window 1), even though there's nothing...
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
February 16, 2016 at 2:08 am
Can you post the execution plans please? Pictures of them are pretty useless as all the interesting stuff is in the properties of the operators.
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
February 16, 2016 at 2:00 am
Stats are created with indexes regardless of whether autocreate stats is on or off. Autocreate determines whether SQL will automatically create 'missing' stats or not.
No, there isn't a DMV. 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
February 16, 2016 at 1:59 am
Create a procedure WITH EXECUTE AS, put the start job in there. User has execute on procedure. Write a small app that just calls the procedure (C#, should be <...
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
February 15, 2016 at 2:11 pm
Google: Glenn Berry diagnostic scripts
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
February 15, 2016 at 2:09 pm
2008 R2 to 2014 or 2012 to 2014 doesn't make the slightest difference. You can't RESTORE ... WITH STANDBY, hence the only way to make a restored DB readable 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
February 15, 2016 at 1:48 pm
Not existing in exec_requests is completely understandable. That DMV only shows executing requests. If a session has opened a transaction, run a query and is now in the sleeping state...
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
February 15, 2016 at 12:04 pm
jasona.work (2/15/2016)
/me looks down, swings foot back and forth
Huh?
My comment wasn't a slight. If someone told me they were testing I'd be surprised because most people don't bother and assume...
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
February 15, 2016 at 11:43 am
Yes.
You're putting the server into a state where should something consume lots of memory (remote desktop with SSMS, large file copies), you could starve the OS of memory, and...
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
February 15, 2016 at 11:42 am
Restoring up-version and applying logs requires that the DB be left in the RESTORING state, meaning it can't be accessed at all. As soon as you RESTORE ... WITH RECOVERY,...
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
February 15, 2016 at 10:17 am
SQL!$@w$0ME (2/15/2016)
MAX and MIN SQL server memory is set to same which is 90GB and it has used all 90 GB allocated.
No, please don't do that. Especially not in combination...
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
February 15, 2016 at 10:08 am
SQL!$@w$0ME (2/15/2016)
What/why is the extra 31 GB used by SQL?
There's no 'extra' here. If you didn't have Locked Pages enabled, Task Manager would be showing the full 90GB for...
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
February 15, 2016 at 9:37 am
Viewing 15 posts - 3,586 through 3,600 (of 49,552 total)