Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


What do you do with a new SQL Server?


What do you do with a new SQL Server?

Author
Message
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45447 Visits: 39944
AndyD (6/12/2008)
Jeff Moden (6/12/2008)

I remember seeing an article on the difference between 0% and 100% fill factors... Dunno if I can find it, again, but I'll look...


I was only regurgitating what is stated in BOL... from my point of view it seems strange that 0% and 100% mean the same thing Hehe


Oh no... sorry. It wasn't a challenge... I agree that's what BOL says... dang, I gotta find that article.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Jeff Moden
Jeff Moden
SSC-Forever
SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)SSC-Forever (45K reputation)

Group: General Forum Members
Points: 45447 Visits: 39944
I found it... them, really.

http://www.sqlmag.com/Articles/ArticleID/19851/19851/pg/2/2.html?Ad=1
http://www.sqlmag.com/Article/ArticleID/20242/sql_server_20242.html

I'm not a "member" of that particular site so I can't see the whole article. What I glean from the two articles is that there used to be a difference in the early days and that there's really no difference now.

What is interesting is, if you scroll down in the 2nd article, you'll find that "PAD INDEX" supposedly makes the 0% and 100% fills even "tighter"... seems like they both leave 1 extra row without it.

--Jeff Moden

RBAR is pronounced ree-bar and is a Modenism for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
Although they tell us that they want it real bad, our primary goal is to ensure that we dont actually give it to them that way.
Although change is inevitable, change for the better is not.
Just because you can do something in PowerShell, doesnt mean you should. Wink

Helpful Links:
How to post code problems
How to post performance problems
Forum FAQs
Andy sql
Andy sql
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1150 Visits: 1301
Perhaps the esteemed Mr Phil Factor would like to get involved in the discussion?
MP-537807
MP-537807
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 121
I set up the alerts on a test system and have database mail enabled with a valid profile (that I can send a test email from). I added the notification to the alerts to use a operator that used this DBMail profile. I generate a test deadlock but the alert never fires and yes the deadlock does happen:
Msg 1205, Level 13, State 45, Line 4
Transaction (Process ID 57) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.

What am I missing here? Alert set up, dbmail set up, operator set up. Alert setup for deadlock as recommended to use the operator that uses dbmail.
Carolyn Richardson
Carolyn Richardson
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1557 Visits: 3449
Check checking did you enable the profile you created as per the article? Did the alert fire into the event log? do any of the other events fire?

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
MP-537807
MP-537807
SSC Rookie
SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)SSC Rookie (30 reputation)

Group: General Forum Members
Points: 30 Visits: 121
I double checked and the profile is enabled. The script to set the jobs to write to the event log worked (one of the dummy job now is set to write to teh application log) but I am still not seeing the deadlock in the logs though.
Alan Vogan
Alan Vogan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1093 Visits: 585
Nice article. We are going through an upgrade to 2005 and it's nice to see what your doing being confirmed by your peers.

I would also add some more notes on hardware set-up. I'm a little weak in this area and like to see more on the initial set-up so I know I'm going to get the most out of the server.

For instance, I didn't know about volume alignment and found the following article very helpful:

http://www.microsoft.com/technet/prodtechnol/sql/bestpractice/pdpliobp.mspx
Carlo Mitchell
Carlo Mitchell
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 37
Great article! I may have missed these but, a couple other items that come to mind:

- Security, who has access and who should or shouldn't have access?
- Service accounts being used.
- Auditing of schema changes.
- Do any tables need to have auditing setup?
- Under backups, are transaction log backups not being done that should be?
- Linked Servers.
- Index usage statistics
Carolyn Richardson
Carolyn Richardson
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1557 Visits: 3449
Try a different alert, I'll be honest I have been lucky enough not to come across any deadlocks in SQL Server 2005 databases I've supported - things have been looking up, the deadlock event was set up and taken from a SQL Server 2000 script.

USE [msdb]
GO
/****** Object: Alert [Deadlock] Script Date: 06/12/2008 17:46:22 ******/
EXEC msdb.dbo.sp_add_alert @name=N'Deadlock',
@message_id=0,
@severity=0,
@enabled=1,
@delay_between_responses=0,
@include_event_description_in=1,
@category_name=N'[Uncategorized]',
@performance_condition=N'SQLServer:Locks|Number of Deadlocks/sec|Database|>|1',
@job_id=N'00000000-0000-0000-0000-000000000000'

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists
Alan Vogan
Alan Vogan
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1093 Visits: 585
Carlo Mitchell (6/12/2008)
Great article! I may have missed these but, a couple other items that come to mind:

- Security, who has access and who should or shouldn't have access?
-


Ack! Security! Another one of those areas I have to read articles on....w00t
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search