ArcGIS Desktop

  • ArcGIS Pro
  • ArcMap

  • My Profile
  • Help
  • Sign Out
ArcGIS Desktop

ArcGIS Online

The mapping platform for your organization

ArcGIS Desktop

A complete professional GIS

ArcGIS Enterprise

GIS in your enterprise

ArcGIS for Developers

Tools to build location-aware apps

ArcGIS Solutions

Free template maps and apps for your industry

ArcGIS Marketplace

Get apps and data for your organization

  • Documentation
  • Support
Esri
  • Sign In
user
  • My Profile
  • Sign Out

Help

  • Home
  • Get Started
  • Map
  • Analyze
  • Manage Data
  • Tools
  • More...

Creating data files for the NIS workspace in SQL Server

Standard GIS storage recommendations favor keeping index and log files separate from vector and tabular business tables. For performance reasons, it is better to position the business, feature, and spatial index tables separately and position FileGroup data files based on their usage patterns. For a multiversioned, highly active editing geodatabase, database files of the VERSIONS FileGroup may be separated and dispersed across available disks to avoid input/output contention.

The following table has the recommended FileGroups to be created for storing the features and tables.

FILEGROUPCONFIGURATION KEYWORD_PARAMETER

NIS_BDATA

Business table

NIS_BINDEX

Business table index

NIS_SDATA

Spatial Index table

NIS_SINDEX

Spatial Index table index

NIS_ADATA

Adds table (versioned)

NIS_AINDEX

Adds table index

NIS_DDATA

Deletes table (versioned)

NIS_DINDEX

Deletes table index

NIS_XMLDOC

XML documents

NIS_XMLIDX

XML documents indexes

NIS_SDEDICT

Data dictionary

NIS_SDEDICTINDEX

Data dictionary index

FileGroups

The following script can be run in SQL Management Studio to add FileGroups.

USE MASTER
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_BDATA] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Bdata01', FILENAME = N'C:\mssql\data\nisdb\nis_Bdata01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_BDATA]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_BINDEX]
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Bindex01', FILENAME = N'C:\mssql\data\nisdb\nis_Bindex01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_BINDEX]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_SDATA] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Sdata01', FILENAME = N'C:\mssql\data\nisdb\nis_Sdata01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_SDATA]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_SINDEX] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Sindex01', FILENAME = N'C:\mssql\data\nisdb\nis_Sindex01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_SINDEX]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_ADATA] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Adata01', FILENAME = N'C:\mssql\data\nisdb\nis_Adata01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_ADATA]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_AINDEX] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Aindex01', FILENAME = N'C:\mssql\data\nisdb\nis_Aindex01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_AINDEX]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_DDATA] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Ddata01', FILENAME = N'C:\mssql\data\nisdb\nis_Ddata01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_DDATA]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_DINDEX] 
GO
ALTER DATABASE [nisbd] ADD FILE (NAME = N'nis_Dindex01', FILENAME = N'C:\mssql\data\nisdb\nis_Dindex01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_DINDEX]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_XMLDOC] 
GO
ALTER DATABASE [nisbd] ADD FILE(NAME = N'nis_Xmldoc_01', FILENAME = N'D:\mssqldata\nisdb\nis_Xmldoc_01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_XMLDOC]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_XMLINDEX] 
GO
ALTER DATABASE [nisbd] ADD FILE(NAME = N'nis_Xmlindex_01', FILENAME = N'D:\mssqldata\nisdb\nis_Xmlindex_01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_XMLINDEX]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_SDEDICT] 
GO
ALTER DATABASE [nisbd] ADD FILE(NAME = N'nis_Sdedict_01', FILENAME = N'D:\mssqldata\nisdb\nis_Sdedict_01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_SDEDICT]
GO
ALTER DATABASE [nisbd] ADD FILEGROUP [NIS_SDEDICTINDEX] 
GO
ALTER DATABASE [nisbd] ADD FILE(NAME = N'nis_Sdedictindex_01', FILENAME = N'D:\mssqldata\nisdb\nis_Sdedictindex_01.NDF' , SIZE = 1, MAXSIZE = 800, FILEGROWTH = 1) TO FILEGROUP [NIS_SDEDICTINDEX]
GO

By setting the data files’ initial size to 1 MB, there is no delay in the creation of the FileGroups. You can then resize the data files to avoid fragmentation.

ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Bdata01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Bindex01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Sdata01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Sindex01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Adata01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Aindex01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Ddata01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Dindex01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Xmldoc_01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Xmlindex_01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Sdedict_01', SIZE = 400MB )
ALTER DATABASE [NISDB] MODIFY FILE ( NAME = N'nis_Sdedictindex_01', SIZE = 400MB )

Use the following to verify FileGroups and data files:

EXEC sp_helpdb nisdb
GO
Note:

Copying and pasting the examples may cause syntax errors.

ArcGIS Desktop

  • Home
  • Documentation
  • Support

ArcGIS Platform

  • ArcGIS Online
  • ArcGIS Desktop
  • ArcGIS Enterprise
  • ArcGIS for Developers
  • ArcGIS Solutions
  • ArcGIS Marketplace

About Esri

  • About Us
  • Careers
  • Esri Blog
  • User Conference
  • Developer Summit
Esri
Tell us what you think.
Copyright © 2020 Esri. | Privacy | Legal