Viewing 15 posts - 2,131 through 2,145 (of 7,499 total)
Very valid questions, but since you are planning on moving database files, (parts of ) your db will be offline for a while (to be able to actually move 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 15, 2011 at 3:12 am
I tested this script:
USE [msdb]
GO
/****** Object: Alert [DBA_LockingTreshold] Script Date: 04/15/2011 08:30:59 ******/
IF EXISTS (SELECT name FROM msdb.dbo.sysalerts WHERE name = N'DBA_LockingTreshold')
EXEC msdb.dbo.sp_delete_alert @name=N'DBA_LockingTreshold'
GO
EXEC msdb.dbo.sp_add_alert...
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 15, 2011 at 2:09 am
"after" is always to late.
We create windows groups for that get the needed access auth on our dev instances. A devs login will only need to be added to that...
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 15, 2011 at 12:18 am
A connection will be registered until the client disconnects ( or if connection pooling is enabled, until it is released from the connection pool (I think this timeout value defaults...
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 15, 2011 at 12:09 am
zygonr (4/14/2011)
I have question, I see the query which you have provided gives us the value of Target SQL server memory in cntr_value.
How do I convert it to...
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 15, 2011 at 12:00 am
I find this article very helpful:
"A Small Collection of I/O Specific DMV Queries"
http://glennberrysqlperformance.spaces.live.com/blog/cns!45041418ECCAA960!2991.entry
By Glenn Berry
There is also a WP to help understand what's going on:
WP SQL2005 Performance_Tuning_Waits_Queues.doc
And for refs I...
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 14, 2011 at 1:51 pm
How long since the box has been rebooted and how big the db size to be loaded.
Are your indexes fragmented ?
In that case, your engine will need to perform...
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 14, 2011 at 1:46 pm
With any 64-bit install of sqlserver you must set the max server memory configuration setting for the instance! or it will eat up all your ram.
Set it to an acceptable...
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 14, 2011 at 1:22 pm
Can you elaborate on how you did configure and are using the alert ?
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 14, 2011 at 1:17 pm
One thing you can do with your current setup is alter the where clause.
where mOnCallAdd.StartOnCalldate = DATEdiff(dd, convert(datetime,'12/31/1899', 101),@currentdate)
This way, if there is an index on your column StartOnCalldate in...
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 14, 2011 at 1:09 pm
Andy also commented wonderful on his blog:http://sqlblog.com/blogs/andy_leonard/archive/2011/04/14/recruiting-sql-server-database-professionals.aspx
Another confirmation of your article being very valid !
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 14, 2011 at 12:54 pm
IMHO your query points to a design flaw.
There is no way this kind of queries will be able to produce a well performing query, based on datetime data, just because...
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 14, 2011 at 12:39 pm
Grant Fritchey (4/14/2011)
Craig Farrell (4/14/2011)
I'm going to assume I'm...
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 14, 2011 at 6:15 am
Jeff Moden (4/14/2011)
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 14, 2011 at 2:16 am
Craig Farrell (4/14/2011)
I'm going to assume I'm just too...
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 14, 2011 at 1:55 am
Viewing 15 posts - 2,131 through 2,145 (of 7,499 total)