Viewing 15 posts - 4,876 through 4,890 (of 7,506 total)
So the queries are known and fixed, just the db is unknown
and the executors have the needed rights to read the data.
- are this individualy single database actions ...
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
May 9, 2008 at 7:33 am
Seing that sqlcat list, this may also add to a well concerned decision:
http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
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
May 9, 2008 at 3:44 am
Hugo Kornelis (5/9/2008)
ALZDBA (5/9/2008)
Hugo Kornelis (5/8/2008)
.Correct me if I'm wrong but IMO if result changes because of a changed index, your query symantics do not reflect what you want 100%!
Hi...
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
May 9, 2008 at 1:20 am
Jeff Moden (5/8/2008)
Hey! What kind of bike is in your avatar?
It's a 1995 Honda NTV650. (The little brother of the Pan European)
It's current evolution is known as "Deauville".
Quit fault...
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
May 9, 2008 at 1:16 am
Hugo Kornelis (5/8/2008)
.
Correct me if I'm wrong but IMO if result changes because of a changed index, your query symantics do not reflect what you want 100%!
In the example you've...
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
May 9, 2008 at 12:59 am
I'd suggest to get rid of the "dynamic" stuff.
( All time ref: http://www.sommarskog.se/dynamic_sql.html )
If you need the same proc in # databases, create it in each database !
( Unless 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
May 9, 2008 at 12:09 am
TheSQLGuru (5/8/2008)
Since this is a 2005 specific forum, I think it is best to use this: sys.dm_io_virtual_file_stats
Indeed I posted the "old" script (grabbed it from the sql2k lib) :blush:
Using...
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
May 8, 2008 at 11:58 pm
You will have to execute the script with a connection to the dodgy database !
If that user was the actual database owner (<> member of db_owner group), it will not...
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
May 8, 2008 at 11:44 pm
This material seems quit interesting ...
- http://www.sql-server-performance.com/articles/per/2000io_config_sannas_p1.aspx
- http://sqlserver-qa.net/blogs/perftune/archive/2008/01/28/3300.aspx
- http://blogs.msdn.com/benjones/archive/2005/09/12/463964.aspx
- http://www.dell.com/content/topics/global.aspx/power/en/ps3q01_muirhead?c=us&cs=555&l=en&s=biz
- http://h71028.www7.hp.com/ERC/downloads/4AA0-2948ENW.pdf
(started at http://whitepapers.zdnet.com/abstract.aspx?docid=166254 )
Some of them are based on SQL2000, but I think the top basic rules are...
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
May 8, 2008 at 2:53 pm
keep in mind in this context "temp table" is an #-named table.
Don't create normal tables in tempdb ! You'll loose them at sqlserver restart time!
Create table #tmp (A int not...
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
May 8, 2008 at 2:41 pm
this script generates "user synchronisation" statements.
Maybe this will help out:
print 'print @@servername + '' / '' + db_name()'
print 'go'
go
declare @username varchar(128)
declare @Musername varchar(128)
declare @UserType Char(1)
declare @sql_stmt varchar(500)
declare @ExcludeWindowsAccounts Char(1)
set @ExcludeWindowsAccounts...
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
May 8, 2008 at 2:37 pm
- can you provide DDL for the objects (including indexes) ?
- many or-s, many functions for filtering (leftx,3) in (...)
may discourage index usage !
Post the execution plan...
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
May 8, 2008 at 2:33 pm
to see if you have IO problems regarding the tempdb you can offcourse always use:
/* track sqlserver IOstall time*/
set nocount on
SELECT ' use ['+ name +']
go'
+ case dbid when 1...
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
May 8, 2008 at 2:25 pm
-We record this at the sqlinstance itself and only grant insert access to that particular table of our "admin" db.
- This just to avoid having issues if your central audit...
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
May 8, 2008 at 7:23 am
:humble:
I'm not worthy to even read this article, but I've been a bad boy and did just that. 😀 Mea culpa.
Clear, to the point, no rocket science involved, practical, very...
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
May 8, 2008 at 4:59 am
Viewing 15 posts - 4,876 through 4,890 (of 7,506 total)