Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

What do you do with a new SQL Server? Expand / Collapse
Author
Message
Posted Thursday, June 12, 2008 6:43 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 36,767, Visits: 31,223
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


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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #515847
Posted Thursday, June 12, 2008 6:54 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: General Forum Members
Last Login: Today @ 8:22 AM
Points: 36,767, Visits: 31,223
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."

(play on words) "Just because you CAN do something in T-SQL, doesn't mean you SHOULDN'T." --22 Aug 2013

Helpful Links:
How to post code problems
How to post performance problems
Post #515852
Posted Thursday, June 12, 2008 7:10 AM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Friday, July 25, 2014 1:39 AM
Points: 1,026, Visits: 1,097
Perhaps the esteemed Mr Phil Factor would like to get involved in the discussion?
Post #515865
Posted Thursday, June 12, 2008 8:54 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 9:52 AM
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.
Post #515999
Posted Thursday, June 12, 2008 9:01 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 12:52 AM
Points: 1,454, Visits: 2,959
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
Post #516006
Posted Thursday, June 12, 2008 9:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, July 30, 2013 9:52 AM
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.
Post #516036
Posted Thursday, June 12, 2008 10:10 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 1,082, Visits: 540
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
Post #516074
Posted Thursday, June 12, 2008 10:45 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 1, 2010 9:01 AM
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
Post #516095
Posted Thursday, June 12, 2008 10:50 AM
UDP Broadcaster

UDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP BroadcasterUDP Broadcaster

Group: General Forum Members
Last Login: Tuesday, July 8, 2014 12:52 AM
Points: 1,454, Visits: 2,959
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
Post #516103
Posted Thursday, June 12, 2008 10:50 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 24, 2014 4:49 PM
Points: 1,082, Visits: 540
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....
Post #516104
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse