Viewing 15 posts - 14,191 through 14,205 (of 49,552 total)
Alexander Suprun (2/21/2013)
I've asked a specific question: 10MB of memory is required for tempdb object and 1Gb is available, is it going to write to disk or not?
Maybe, maybe...
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 22, 2013 at 3:12 am
Take a look at this article. http://www.sqlservercentral.com/articles/65804/, the section on data purity errors.
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 21, 2013 at 2:00 pm
I recommend you turn it off. On a server with nothing other than SQL it will provide no benefit as there's nothing to boost SQL's priority over and you run...
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 21, 2013 at 1:59 pm
ausman (2/21/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
February 21, 2013 at 11:08 am
bangsql (2/21/2013)
2. no of physical cpu = no of tempdb files.
Temp tables and table variables are always in TempDB, they're both tables, they're both entered in the TempDB system tables,...
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 21, 2013 at 10:43 am
Why did you change the DB to full recovery in the first place? Full recovery makes log management harder (you need scheduled log backups), not easier.
A DB in simple...
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 21, 2013 at 10:41 am
ScottPletcher (2/21/2013)
Are Transaction_Numbers -- i.e. clustered key values -- added in ascending sequence?If so, make sure SQL is sorting the rows before doing the INSERTs.
Why?
The exec plans are 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
February 21, 2013 at 10:31 am
briancampbellmcad (2/21/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
February 21, 2013 at 9:08 am
sqlskj4000 (2/20/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
February 20, 2013 at 3:07 pm
You're correct.
sp_whoisactive must exclude itself from the report, because it would obviously be running while it's running. 😀
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 20, 2013 at 2:56 pm
rferreira.dba (2/20/2013)
Let me put this another way: Is there any valid reason for Microsoft not to fix this?
Because there's nothing broken here?
The kb article you referenced refers to 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
February 20, 2013 at 2:10 pm
If the query is runnable, it's in the queue for scheduling back onto the processor and is not waiting for anything (other than some time on the CPU). If 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
February 20, 2013 at 10:18 am
Start a blog, write some articles, present at conferences/SQLSaturdays, answer questions on forums.
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 20, 2013 at 10:17 am
Don't use Task Manager to check SQL Server's memory, it can display completely incorrect (far too low) values.
Perfmon counter - Total Server 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
February 20, 2013 at 10:16 am
Again, daily log backups??? Sure that's good enough?
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 20, 2013 at 10:13 am
Viewing 15 posts - 14,191 through 14,205 (of 49,552 total)