A blog by Jose Barreto, a member of the File Server team at Microsoft.
All messages posted to this blog are provided "AS IS" with no warranties, and confer no rights.
Information on unreleased products are subject to change without notice.
Dates related to unreleased products are estimates and are subject to change without notice.
The content of this site are personal opinions and might not represent the Microsoft Corporation view.
The information contained in this blog represents my view on the issues discussed as of the date of publication.
You should not consider older, out-of-date posts to reflect my current thoughts and opinions.
© Copyright 2004-2012 by Jose Barreto. All rights reserved.
Follow @josebarreto on Twitter for updates on new blog posts.
I am doing a little demo this week and it includes a simple SQL Server script to generate activity on the network while I demo SMB2 durability.
First, the database is created:
CREATE DATABASE [Sales] ON PRIMARY ( NAME = N'Sales', FILENAME = N'\\FSA\SQLDB\Sales.mdf' , SIZE = 2GB , MAXSIZE = 8GB, FILEGROWTH = 1GB )LOG ON ( NAME = N'Sales_log', FILENAME = N'\\FSA\SQLDB\Sales_log.ldf' , SIZE = 1GB , MAXSIZE = 2GB , FILEGROWTH = 10%)GO
CREATE TABLE [dbo].[Product]( [ProductId] [uniqueidentifier] DEFAULT NEWID() NOT NULL, [ProductName] [nchar](50) NULL, [ProductDescription] [nchar](3000) NULL, [ProductPrice] MONEY NULL) ON [PRIMARY]GO
Then, the script to keeps the database a little busy:
USE [Sales]GOWHILE (1=1) BEGIN TRUNCATE TABLE [Sales].[dbo].[Product] DECLARE @Record INT SET @Record=1 WHILE @Record<=10000 BEGIN INSERT INTO [Sales].[dbo].[Product] ([ProductName] ,[ProductDescription],[ProductPrice]) VALUES ('Product ' + STR(@Record), 'Description ' + STR(@Record), @Record*100/3) SET @RECORD = @RECORD+1 END SELECT COUNT(ProductID) as RecordsCreated FROM [Sales].[dbo].[Product] END
Simple stuff. Just so SQL Server can generate some activity that can be shown in Task Manager's Network tab while other things happen... :-)