SQL Server 2k Enterprise sp3
Windows 2k Server
XeonX2*2 2GMhz2G RAMRAID5
After excuting 'dbcc sqlperf(WAITSTATS)',The WaitType,including
RESOURCE_QUEUELATCH_EXCXPACKETPAGEIOLATCH_SH , often appears .
But CPU's Usage is less than 60% and RAM has 90M free.
http://sqldev.net/misc/waittypes.htm did not tell me how to optimizing SQL
server performance .
I don't know whether I should add the CPU ,or the RAM, or anything else.
I want the SQL Server to do its best.
Thanks
Are you experiencing any kind of problems on your sql server that may need
more memory?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Showing posts with label dbcc. Show all posts
Showing posts with label dbcc. Show all posts
Thursday, March 8, 2012
Tuesday, March 6, 2012
About Wait Type
SQL Server 2k Enterprise sp3
Windows 2k Server
XeonX2*2 2GMhz£¬2G RAM£¬RAID5
After excuting 'dbcc sqlperf(WAITSTATS)',The WaitType,including
RESOURCE_QUEUE¡¢LATCH_EX¡¢CXPACKET¡¢PAGEIOLATCH_SH, often appears .
But CPU's Usage is less than 60% and RAM has 90M free.
http://sqldev.net/misc/waittypes.htm did not tell me how to optimizing SQL
server performance .
I don't know whether I should add the CPU ,or the RAM, or anything else.
I want the SQL Server to do its best.
ThanksAre you experiencing any kind of problems on your sql server that may need
more memory?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Windows 2k Server
XeonX2*2 2GMhz£¬2G RAM£¬RAID5
After excuting 'dbcc sqlperf(WAITSTATS)',The WaitType,including
RESOURCE_QUEUE¡¢LATCH_EX¡¢CXPACKET¡¢PAGEIOLATCH_SH, often appears .
But CPU's Usage is less than 60% and RAM has 90M free.
http://sqldev.net/misc/waittypes.htm did not tell me how to optimizing SQL
server performance .
I don't know whether I should add the CPU ,or the RAM, or anything else.
I want the SQL Server to do its best.
ThanksAre you experiencing any kind of problems on your sql server that may need
more memory?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
About Wait Type
SQL Server 2k Enterprise sp3
Windows 2k Server
XeonX2*2 2GMhz2G RAMRAID5
After excuting 'dbcc sqlperf(WAITSTATS)',The WaitType,including
RESOURCE_QUEUELATCH_EXCXPACKETPAGE
IOLATCH_SH, often appears .
But CPU's Usage is less than 60% and RAM has 90M free.
http://sqldev.net/misc/waittypes.htm did not tell me how to optimizing SQL
server performance .
I don't know whether I should add the CPU ,or the RAM, or anything else.
I want the SQL Server to do its best.
ThanksAre you experiencing any kind of problems on your sql server that may need
more memory?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Windows 2k Server
XeonX2*2 2GMhz2G RAMRAID5
After excuting 'dbcc sqlperf(WAITSTATS)',The WaitType,including
RESOURCE_QUEUELATCH_EXCXPACKETPAGE
IOLATCH_SH, often appears .
But CPU's Usage is less than 60% and RAM has 90M free.
http://sqldev.net/misc/waittypes.htm did not tell me how to optimizing SQL
server performance .
I don't know whether I should add the CPU ,or the RAM, or anything else.
I want the SQL Server to do its best.
ThanksAre you experiencing any kind of problems on your sql server that may need
more memory?
Vikram Jayaram
Microsoft, SQL Server
This posting is provided "AS IS" with no warranties, and confers no rights.
Subscribe to MSDN & use http://msdn.microsoft.com/newsgroups.
Sunday, February 19, 2012
About rebuilding index
Hi,
Maybe a silly question, but... Are DBCC DBREINDEX and sqlmaint -RebldIdx doing exactly the same thing ? I mean, I know they are both rebuilding index, with optionnally precising a new fillfactor, but are they processing this operation by the same way ? If not, which is best ?
ThanksStick with DBCC DBREINDEX - safer & works just as well.
If you are working on very large tables then you would start looking at options at that point.
Cheers,
SG|||That's just what I was suspecting.
Thanks for answer :)
Maybe a silly question, but... Are DBCC DBREINDEX and sqlmaint -RebldIdx doing exactly the same thing ? I mean, I know they are both rebuilding index, with optionnally precising a new fillfactor, but are they processing this operation by the same way ? If not, which is best ?
ThanksStick with DBCC DBREINDEX - safer & works just as well.
If you are working on very large tables then you would start looking at options at that point.
Cheers,
SG|||That's just what I was suspecting.
Thanks for answer :)
Subscribe to:
Comments (Atom)