Viewing 15 posts - 1,246 through 1,260 (of 7,503 total)
It took me some time to crawl back into working position after reading this finding.
Completely astonished by the simplicity of the solution.
Huge thank you for notifying and publishing another...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 8, 2013 at 8:16 am
Since your query doesn't return any columns of table mcpITEMTASKS, I would certainly remove the update lock !
hence ... all your deadlock problems for this query case will vanish !
The...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 2, 2013 at 12:06 am
please provide the query plan(s).
My guess is the index is being scanned, so the updlock may indeed block it all.
p.s. are you sure this is a SQL2012 instance ? The...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
April 1, 2013 at 2:06 am
an index sonsists of two parts :
a keys section and an included-columns section.
Books online shows how many columns or bytes each can have.
http://msdn.microsoft.com/en-us/library/ms143432.aspx ( see "Columns per index key")
This ref...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2013 at 8:57 am
Koen Verbeeck (3/28/2013)
Your signature gets bigger by the years 😉
not only my signature 😉
In general: my...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2013 at 8:46 am
- Is sqlbrowser running ?
- are you specifying the port number in your connection data ? If yes: did you modify it ?
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2013 at 8:45 am
so far for naming conventions 😉
convering index as a concept means a query ( or part of it ) can be served directly by the index itself, without having the...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2013 at 5:50 am
Have a look at Roys marvelous series: What, when and who? Auditing 101[/url]
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2013 at 5:02 am
On top of the previous replies you may want to double check the need for this instance to enable ad hoc workload optimization.
( just to prevent cache spill ram for...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 28, 2013 at 4:56 am
and above all ... meet your peers !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
March 12, 2013 at 8:35 am
indeed.
( for both sqlserver instances please, RTM is already a couple of years old and there are many fixes implemented with the SPs )
You only need to apply the...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 21, 2013 at 11:54 pm
fatinnadiah88 (2/21/2013)
Both of the servers shows this information:Edition: Enterprise Edition
Product version: 10.50.1600.1
Product level: RTM
You posted in a SQL 2005 forum !
Your server is SQL2008R2 !
btw the current service pack...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 21, 2013 at 5:09 am
Can you post these properties of your two sqlserver instances ?
Select Serverproperty('Edition') as Edition
, Serverproperty('ProductVersion') as ProductVersion
,...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 21, 2013 at 3:06 am
is the data for your computed column considered static ?
if yes, use an insert trigger that gets that data and puts is in a regular column.
if no,
How about...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 20, 2013 at 12:44 am
I would double check:
1- network bandwith and consumption ( drastically enhanced with SQL2008 ! in case you still need an upgrade reason )
2- I/O subsystem performance
3- ram pressure
of...
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
February 20, 2013 at 12:41 am
Viewing 15 posts - 1,246 through 1,260 (of 7,503 total)