Using a SAN to Initialize Replication

I’ve chatted to a few customers about the possibnility of using a SAN based snapshot to initialise transactional replication. This can be fantastic when you are using a replica to provide “near real time” reporting. Up until now, documentation has been a bit light on the ground on this apporoach, and people have been cautious to try…

1

Dimensional Modelling and Cube Building 101

Thanks to everyone who came to the Dublin SQL users Group session on Tuesday. I hope that we addressed some aspects of “cube fear” that is common in even very experienced relational professionals. For me just being comfortable building that first cube is a great feeling. We got some great feedback with a a 95%…

1

Why Not to Sysprep SQL Server

If you do a lot of installs its a good idea to have an automated process for provisioning SQL Server. A lot of people try to use "sysprep" Here’s a few reasons why not to use sysprep. Its not supported by Microsoft CSS. SQL will not work properly until it is "renamed". If you have…

5

Troubleshooting SQL 2008 Installation (Access Denied)

I have to say that the improvements in the SQL 2008 installation have been pretty good to me. We have a Hyper-V lab with automated SQL installation based on configuration templates which works really well. We can get a box provisioned with SQL 2008 in under 20 minutes. We can do it in a few…

0

Configuring Max Worker Threads in SQL 2005

One of the changes in SQL 20005 is that the default value of Max Worker Threads has changed from 255 to zero, meaning that SQL Server now automatically determines the optimum number of threads. You can determine the maximum number of threads SQL Server has actually configured and how many it is currently using by…

1

Last Exam to Go on SQL Ranger 04!!

Out last written exam tomorrow!!! There was definitely a sense of the end of a long journey when we finished the last class today (VLDB scenario). I don’t think people will be jumping for the pub on Friday as everyone will be flopping down in bed 😉 The SQL ranger team and centre of Excellence…

1

What Does Lock Pages in Memory Do

I thought I would post some clarification on what the famous "Lock Pages in Memory" policy setting does and does not do. 1. It prevents the operating system from stealing the buffer pool (see previous blog on buffer pool), thus shrinking the working set. 2. It is NOT available on Standard Edition. 3. It ALSO…

1

How to set MAX_SERVER_MEMORY

OK I’m on a roll here blogging as my brain is full up on the MCA course. Here’s a good tip on how to calculate the MAX_SERVER_MEMORY a) calculate worker threads (assuming set correctly, as default max 255 may be too low for huge beasts) select max_workers_count from sys.dm_os_sys_info b) Figure out thread stack size…

0

SQL Server Memory Architecture. Myth Busting and how sad is AWE/32 bit.

I have a little picture below to show how memory is broken up in the SQL Server Working set. Some key Myths to dispel: a) The Max Memory Setting only sets the target memory for the buffer pool not for the whole of SQL Server working set. So do not set it as high as…

2

The SQL Server Disaster Game

I have been doing a great course with Paul Randal on disaster recovery for SQL Server. He has a great blog on just about everything to do with DBCC and disk structures and recovery. See http://www.sqlskills.com/blogs/paul/default.aspx Here is a little flow chart I made up for some fun:   The art of the disaster game…

0