Viewing 15 posts - 33,721 through 33,735 (of 49,552 total)
Sounds like parameter sniffing.
Can you post the store proc and the actual execution plan (not estimated, so not retrieved from cache) for both a fast and a slow query 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
March 3, 2010 at 5:58 am
Order of conditions in a where clause is does not affect performance. SQL will use the best index that it can find, based on parameter values and cardinality, not on...
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
March 3, 2010 at 5:57 am
Only way you're likely to improve that is with indexes. The query is simple enough that there are no changes that you can make there that will improve the performance
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
March 3, 2010 at 5:52 am
HowardW (3/3/2010)
It's something SQL Server could optimise better internally when static parameters are being evaluated.
How?
There's one fundamental rule that the optimiser has to follow. Plans must be safe 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
March 3, 2010 at 5:50 am
Maybe, depends what kind of disaster. If the server is still up and SQL is still running and the log for that database is still available, you should be able...
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
March 2, 2010 at 10:52 pm
skjoldtc (3/2/2010)
I would guess that management doesn't know about it. On other sites I've seen user i.d.s and passwords posted.
It terrifies me when I see posts along the lines...
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
March 2, 2010 at 10:30 pm
We can't tell you what kind of questions the exam will have without violating the NDA that everyone writing the exam has to accept.
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
March 2, 2010 at 10:17 pm
The skills covered in the exam are listed here - http://www.microsoft.com/learning/en/us/exam.aspx?ID=70-432&locale=en-us#tab2 If notification services is not listed there, then it's not part of the exam.
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
March 2, 2010 at 10:17 pm
Paul, see 3rd post in this thread. (I can't tell if that's the full and complete output though)
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
March 2, 2010 at 10:12 pm
mike mcneer (3/2/2010)
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
March 2, 2010 at 1:42 pm
Don't run profiler GUI on the server, run it on a client and point it at the server.
Don't run profiler GUI against a busy production server. Use a server-side trace...
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
March 2, 2010 at 1:07 pm
The total size of a page is 8192 bytes. 8kB = 8*1024 bytes = 8192 bytes. So the number given in the course was slightly off.
8060 is the max size...
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
March 2, 2010 at 1:03 pm
Nick, what's the exact message you're seeing in the log? (obfuscate domain and DB names if you like)
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
March 2, 2010 at 1:00 pm
mike mcneer (3/2/2010)
Maybe SQL is detecting some type of corruption and is kicking of the dbcc checkdb to verify consistency.
SQL won't run checkDB automatically. It's a very CPU and IO...
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
March 2, 2010 at 12:58 pm
It was supposed to have been fixed in SP2, but honestly, I haven't even thought about this issue for a while, I haven't tested it.
Putting the column in the include...
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
March 2, 2010 at 11:39 am
Viewing 15 posts - 33,721 through 33,735 (of 49,552 total)