Viewing 15 posts - 16,276 through 16,290 (of 49,552 total)
The error is because page locking is disabled, not because it's allowed. If you're disabling it (USE mydb ALTER INDEX idx_mytable ON mytable (ALLOW_PAGE_LOCKS = OFF )), you're causing 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 5, 2012 at 8:15 am
Start by reading chapter 3 of http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/
Don't guess as to causes and fixes. Identify what queries are using a lot of CPU and tune those specifically. If you change settings...
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 5, 2012 at 7:25 am
Please post new questions in a new thread. Thanks
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 5, 2012 at 6:36 am
Because executing a query plan takes CPU. If the plan is not efficient then it takes more CPU than if it were efficient.
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 5, 2012 at 2:05 am
SQLSACT (10/4/2012)
What I'm trying to understand is which of your resources are taxed the most when dealing with bad parameter sniffing
CPU usually. IO maybe, depending whether the data is in...
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 5, 2012 at 1:34 am
Please read through these - Managing Transaction Logs[/url]
http://www.sqlservercentral.com/articles/Transaction+Log/72488/
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 5, 2012 at 1:32 am
Pages are not moved into memory, they are copied.
If a page is modified in memory it'll be written back to disk sometime, there's no importance as to when 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
October 5, 2012 at 1:25 am
sainatth.wagh (10/4/2012)
Also could you please share some dumps or important points and chapters that I need to focus for my exam 70-433.
My mail id:sainatth.wagh@gmail.com
Waiting for your reply...
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 4, 2012 at 11:20 am
What will error is trying to reorganise with page locks off. Rebuild doesn't care and certainly doesn't need page locks off.
Can you post that error?
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 4, 2012 at 11:08 am
Not blocking as in locks, just query operators that require the entire result set before they can process. It's easy to figure out, what operations (within a query) require 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
October 4, 2012 at 11:06 am
Nope, only Prometric. They're the only people who offer the MS exams.
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 4, 2012 at 10:56 am
Absolutely. The query processor knows nothing whatsoever about a disk. Anything it needs to read for any reason must be brought into memory first if it's not already in 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
October 4, 2012 at 10:29 am
Why are you turning page locks off? Index rebuilds lock at the table level, so that setting won't affect them, but with page locks off you won't be able to...
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 4, 2012 at 10:26 am
n00bDBA (10/4/2012)
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 4, 2012 at 10:24 am
The prometric website (http://www.prometric.com/)
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 4, 2012 at 9:59 am
Viewing 15 posts - 16,276 through 16,290 (of 49,552 total)