Sign in
|
Join
|
Help
Home
Blogs
WordPress Blogs
Media
All Tags
»
windows
»
sql server
»
performance
(
RSS
)
MVP WordPress Blogs
Loading...
Tags
.NET
Advisories / Bulletins
ASP.NET
C#
Community
ConfigMgr 2007
Digital Media
Events
Exchange
General
General Security News
Media Center
Microsoft
News
Rants
Security
Sharepoint
SPPS03_Tips
SQL Server
System Center
Tools
VB
Vista
Windows 7
Windows Server
Browse Blog Posts by Tags
Showing related tags and posts for the
Blogs
application. See
all tags in the site
.NET
/3gb
2000
2005
32 bit
3gb
64 bit
application
awe
buffers
disk space
dmv
edition
enterprise
hardware
i/o
indexes
instances
management
memory
microsoft
monitoring
pae
paging out
perflib
resource
security
server
sysmon
system
task manager
usage
verison
worker threads
x64
SQL Server error: messages are appearing when the working set of SQL Server 2005 process reaches 50 percent of the memory that is committed to the process.
Have you seen the above message within the SQL Server error logs? If not then no need to worry and make sure to continue your performance monitoring tasks. So when to be concerned! It is evident that SQL Server 2005 component handles memory differently...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Fri, Mar 7 2008
Filed under:
Filed under:
sql server
,
performance
,
memory
,
dmv
,
windows
,
2000
,
2005
,
awe
,
64 bit
,
monitoring
,
worker threads
,
paging out
,
buffers
,
verison
How SQL Server manages when a database is created in terms of I/O and disk usage?
One of the best features you have in the SQL Server is to create database data file (additional) on fly without having a slow performance affect on existing connections. But think about how SQL Server manages to use server threads for the data file that...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jan 29 2008
Filed under:
Filed under:
sql server
,
performance
,
management
,
indexes
,
windows
,
i/o
,
sysmon
,
disk space
,
usage
,
resource
,
perflib
,
worker threads
,
task manager
More than 3GB memory is not used even though boot.ini has these switches on /3GB /PAE /AWE.
Yet another AWE memory settings blog post here that I'm posting for the issues we have had recently. Before going into details review about 3GBPAE blurb here and also refer to this KBA274750 to enable more than 2GB memory within your SQL Server Enterprise...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Thu, Aug 23 2007
Filed under:
Filed under:
sql server
,
performance
,
memory
,
security
,
windows
,
edition
,
enterprise
,
instances
,
awe
,
pae
,
3gb
32bit vs 64 bit what other factors you need to consider?
Is 64 bit means more memory? Yes, to be precise. Microsoft has been investing heavily on X64 bit and within couple of years there will be no more development on 32-bit applications, as per the recent road map. So within 32-bit application it is one of...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Aug 14 2007
Filed under:
Filed under:
sql server
,
performance
,
memory
,
server
,
windows
,
x64
,
system
,
hardware
,
32 bit
,
64 bit
/3GB /PAE and AWE blurb what is it you hear within your environment?
You might have come across a situation to have a better understanding on what /3GB or /PAE switch means that are referred in documentations and forums you go on. I will try my best to give you the notes what I have understood so far in this regard. From...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Wed, Jul 25 2007
Filed under:
Filed under:
sql server
,
performance
,
management
,
memory
,
microsoft
,
security
,
server
,
windows
,
awe
,
/3gb
,
pae
.Net framework 3.5 beta1 - get now for new features
If you are building on the new features in the .NET Framework 3.0, such as Windows Workflow Foundation (WF), Windows Communication Foundation (WCF), Windows Presentation Foundation (WPF), and Windows CardSpace, you'll want to preview the The .NET...
Posted to
SQLServer-QA.net - Knowledge Sharing Network (SSQA.net)
by on Tue, Jul 17 2007
Filed under:
Filed under:
application
,
sql server
,
performance
,
windows
,
.NET
Page 1 of 1 (6 items)