Systems Administrator

namerg

<div>
<div class="content wysiwyg-content">
We have a SQL and Windows Server 2008 R2, 16GB RAM and 16383 MB for total paging file size in total drives.<br />
C drive is 100 GB<br />
D Drive is 200 GB<br />
<br />
Takes forever to login in. It is a virtual vm.<br />
<br />
Do you think the paging file is set wrong ?<br />
<br />
Thanks for your help
</div>
</div>


We have a SQL and Windows Server 2008 R2, 16GB RAM and 16383 MB for total paging file size in total drives.
C drive is 100 GB
D Drive is 200 GB

Takes forever to login in. It is a virtual vm.

Do you think the paging file is set wrong ?

Thanks for your help

Recommended Paging File size SQL Box ?

This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.

Windows OS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Windows Server 2008 and Windows Server 2008 R2, based on the Microsoft Vista codebase, is the last 32-bit server operating system released by Microsoft. It has a number of versions, including including Foundation, Standard, Enterprise, Datacenter, Web, HPC Server, Itanium and Storage; new features included server core installation and Hyper-V.

Windows Server 2008

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.