I am using VB6(SP6) / CR(8.0.1) / WISE INSTALLER(8.1) to distribute a small program. The data is all contained in MS Access 2000 tables and I am using ADO to create each report recordset.
In CR designer I use a TTX file to design the report. This TTX file contains all colums from the recordset and their descriptions i.e. Name, Type, Length and example data.
I create a distribution CD using Wise Installer. Once installed on a Win98, Win2000, Win XP computer everything runs great until the user attempts to run any of the CR reports. On screen the SQL query runs and then calls the CR report. The CR viewer appears and immediately we get an "Out of Memory" error response from CR.
My only remedy is to install MS Office Pro or MS Access 2000-2002. I have use (paid for support) at VB, CR and Wise and received no fix for this problem. VB says it CR, CR says its VB and Wise simply doesn't know?
Thanks in advance for any help on this problem...Maybe you have a memory leak in your VB program?|||Don't think this is the problem... as installing access or office pro solves the problem. This could not fix a memory leak inside the vb program. This problem only occurs if we install to a new computer..
Thanks for your reply
Showing posts with label memory. Show all posts
Showing posts with label memory. Show all posts
Sunday, March 11, 2012
CPU, Physical IO, & Memory Usage
I was wondering about what the values in Management->Current
Activity->Process Info represent. Are the values for CPU, Physical IO, &
Memory Usage cumulative or do they represent a max or a current value?
The reason I'm wondering is that I saw a large value for Memory Usage by a
process recently. The value was in the millions. Most other processes had
values < 100 and some went up to 4000 or so.
Should I be worrying about such a large value for any of these parameters?
Thanks
MG
They are cumulative values from the time the user logged on. For the most
part they are pretty useless.
Andrew J. Kelly SQL MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:A0B603E2-0C4A-4A5A-839F-DE3CB94FCE42@.microsoft.com...
>I was wondering about what the values in Management->Current
> Activity->Process Info represent. Are the values for CPU, Physical IO, &
> Memory Usage cumulative or do they represent a max or a current value?
> The reason I'm wondering is that I saw a large value for Memory Usage by a
> process recently. The value was in the millions. Most other processes
> had
> values < 100 and some went up to 4000 or so.
> Should I be worrying about such a large value for any of these parameters?
> Thanks
> --
> MG
Activity->Process Info represent. Are the values for CPU, Physical IO, &
Memory Usage cumulative or do they represent a max or a current value?
The reason I'm wondering is that I saw a large value for Memory Usage by a
process recently. The value was in the millions. Most other processes had
values < 100 and some went up to 4000 or so.
Should I be worrying about such a large value for any of these parameters?
Thanks
MG
They are cumulative values from the time the user logged on. For the most
part they are pretty useless.
Andrew J. Kelly SQL MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:A0B603E2-0C4A-4A5A-839F-DE3CB94FCE42@.microsoft.com...
>I was wondering about what the values in Management->Current
> Activity->Process Info represent. Are the values for CPU, Physical IO, &
> Memory Usage cumulative or do they represent a max or a current value?
> The reason I'm wondering is that I saw a large value for Memory Usage by a
> process recently. The value was in the millions. Most other processes
> had
> values < 100 and some went up to 4000 or so.
> Should I be worrying about such a large value for any of these parameters?
> Thanks
> --
> MG
Thursday, March 8, 2012
CPU, Physical IO, & Memory Usage
I was wondering about what the values in Management->Current
Activity->Process Info represent. Are the values for CPU, Physical IO, &
Memory Usage cumulative or do they represent a max or a current value?
The reason I'm wondering is that I saw a large value for Memory Usage by a
process recently. The value was in the millions. Most other processes had
values < 100 and some went up to 4000 or so.
Should I be worrying about such a large value for any of these parameters?
Thanks
--
MGThey are cumulative values from the time the user logged on. For the most
part they are pretty useless.
Andrew J. Kelly SQL MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:A0B603E2-0C4A-4A5A-839F-DE3CB94FCE42@.microsoft.com...
>I was wondering about what the values in Management->Current
> Activity->Process Info represent. Are the values for CPU, Physical IO, &
> Memory Usage cumulative or do they represent a max or a current value?
> The reason I'm wondering is that I saw a large value for Memory Usage by a
> process recently. The value was in the millions. Most other processes
> had
> values < 100 and some went up to 4000 or so.
> Should I be worrying about such a large value for any of these parameters?
> Thanks
> --
> MG
Activity->Process Info represent. Are the values for CPU, Physical IO, &
Memory Usage cumulative or do they represent a max or a current value?
The reason I'm wondering is that I saw a large value for Memory Usage by a
process recently. The value was in the millions. Most other processes had
values < 100 and some went up to 4000 or so.
Should I be worrying about such a large value for any of these parameters?
Thanks
--
MGThey are cumulative values from the time the user logged on. For the most
part they are pretty useless.
Andrew J. Kelly SQL MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:A0B603E2-0C4A-4A5A-839F-DE3CB94FCE42@.microsoft.com...
>I was wondering about what the values in Management->Current
> Activity->Process Info represent. Are the values for CPU, Physical IO, &
> Memory Usage cumulative or do they represent a max or a current value?
> The reason I'm wondering is that I saw a large value for Memory Usage by a
> process recently. The value was in the millions. Most other processes
> had
> values < 100 and some went up to 4000 or so.
> Should I be worrying about such a large value for any of these parameters?
> Thanks
> --
> MG
CPU, Physical IO, & Memory Usage
I was wondering about what the values in Management->Current
Activity->Process Info represent. Are the values for CPU, Physical IO, &
Memory Usage cumulative or do they represent a max or a current value?
The reason I'm wondering is that I saw a large value for Memory Usage by a
process recently. The value was in the millions. Most other processes had
values < 100 and some went up to 4000 or so.
Should I be worrying about such a large value for any of these parameters?
Thanks
--
MGThey are cumulative values from the time the user logged on. For the most
part they are pretty useless.
--
Andrew J. Kelly SQL MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:A0B603E2-0C4A-4A5A-839F-DE3CB94FCE42@.microsoft.com...
>I was wondering about what the values in Management->Current
> Activity->Process Info represent. Are the values for CPU, Physical IO, &
> Memory Usage cumulative or do they represent a max or a current value?
> The reason I'm wondering is that I saw a large value for Memory Usage by a
> process recently. The value was in the millions. Most other processes
> had
> values < 100 and some went up to 4000 or so.
> Should I be worrying about such a large value for any of these parameters?
> Thanks
> --
> MG
Activity->Process Info represent. Are the values for CPU, Physical IO, &
Memory Usage cumulative or do they represent a max or a current value?
The reason I'm wondering is that I saw a large value for Memory Usage by a
process recently. The value was in the millions. Most other processes had
values < 100 and some went up to 4000 or so.
Should I be worrying about such a large value for any of these parameters?
Thanks
--
MGThey are cumulative values from the time the user logged on. For the most
part they are pretty useless.
--
Andrew J. Kelly SQL MVP
"MGeles" <michael.geles@.thomson.com> wrote in message
news:A0B603E2-0C4A-4A5A-839F-DE3CB94FCE42@.microsoft.com...
>I was wondering about what the values in Management->Current
> Activity->Process Info represent. Are the values for CPU, Physical IO, &
> Memory Usage cumulative or do they represent a max or a current value?
> The reason I'm wondering is that I saw a large value for Memory Usage by a
> process recently. The value was in the millions. Most other processes
> had
> values < 100 and some went up to 4000 or so.
> Should I be worrying about such a large value for any of these parameters?
> Thanks
> --
> MG
Cpu Usage 100% On 6.5 Sql
we have CPU Usage upto almost 100% i increased the tempdb, and master to almost double the size
then we increased the memory to high amount.
does anyone have suggestion pls help since it running too slow, since we did an upgradeUpgrade from what?
To 6.5?
Turn on Profiler to see what's going on.
How's is you r box configured.
Is SQL the only service on the box?|||Sorry Brett, no profiler on MS-SQL 6.5.
I'd be interested to know what the hardware/OS/software configuration is. MS-SQL 6.5 would run on a bare-bones Pentium, and maybe even on a 486. Some of those machines had 512 Kb of RAM or less.
I don't know that we even know enough to ask good questions yet, much less offer suggestions for how to fix the problem(s).
Is an upgrade to hardware/software less than five years old possible?
-PatP|||Sorry for being so incomplete
I am on window 2000 server running 6.5 sql , had upgraded the vendor application that runs on 6.5 this server ( only thing on box)
ram 3 gb and server 1.4 mhz with raid drive
was running well till this upgrade now.
we increased temp db, master , memory (sql configuration)
size of database 20 gb|||When you use the NT Task Manager, is SQL Server actually running the CPU wild, or is it only part of your problem?
There was a known problem prior to sp5 where SQL Server would go mad trying to manage more than 2 Gb of RAM. I assume that you are at sp6, right?
Try to use sp_who to identify long running tasks, then DBCC INPUTBUFFER to determine what SQL statements those tasks are running.
-PatP|||Yes sql is causing the wild ness
and i taught that 6.5 has only uptill spack 5a
http://www.microsoft.com/sql/downloads/servicepacks.asp
My window 2000 server has service pack 4|||You can try to use SQL Trace to catch some of the activity (queries) in the server. SQL Trace is the SQL Profiler ancestor.
What sort of application is this? Can you take parts of it down to narrow your search? And also, has the vendor said anything like "Oh, yeah. I remember this happened to another client with that setup."|||It was not tested on 6.5 but on 2000 ,
Now they are saying|||If SQL-2000 is an option, go there, NOW!
then we increased the memory to high amount.
does anyone have suggestion pls help since it running too slow, since we did an upgradeUpgrade from what?
To 6.5?
Turn on Profiler to see what's going on.
How's is you r box configured.
Is SQL the only service on the box?|||Sorry Brett, no profiler on MS-SQL 6.5.
I'd be interested to know what the hardware/OS/software configuration is. MS-SQL 6.5 would run on a bare-bones Pentium, and maybe even on a 486. Some of those machines had 512 Kb of RAM or less.
I don't know that we even know enough to ask good questions yet, much less offer suggestions for how to fix the problem(s).
Is an upgrade to hardware/software less than five years old possible?
-PatP|||Sorry for being so incomplete
I am on window 2000 server running 6.5 sql , had upgraded the vendor application that runs on 6.5 this server ( only thing on box)
ram 3 gb and server 1.4 mhz with raid drive
was running well till this upgrade now.
we increased temp db, master , memory (sql configuration)
size of database 20 gb|||When you use the NT Task Manager, is SQL Server actually running the CPU wild, or is it only part of your problem?
There was a known problem prior to sp5 where SQL Server would go mad trying to manage more than 2 Gb of RAM. I assume that you are at sp6, right?
Try to use sp_who to identify long running tasks, then DBCC INPUTBUFFER to determine what SQL statements those tasks are running.
-PatP|||Yes sql is causing the wild ness
and i taught that 6.5 has only uptill spack 5a
http://www.microsoft.com/sql/downloads/servicepacks.asp
My window 2000 server has service pack 4|||You can try to use SQL Trace to catch some of the activity (queries) in the server. SQL Trace is the SQL Profiler ancestor.
What sort of application is this? Can you take parts of it down to narrow your search? And also, has the vendor said anything like "Oh, yeah. I remember this happened to another client with that setup."|||It was not tested on 6.5 but on 2000 ,
Now they are saying|||If SQL-2000 is an option, go there, NOW!
Saturday, February 25, 2012
CPU and memory usage
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.Unfortunatly there is not a straight answer for your query.
My first question is are you sure its SQL Server that causing it, i.e. have
you looked into TASK MANAGER to see what process has the most CPU time ?
You could also set up a Performance check under Administration Tool, you can
set up CPU as one of the things it check.
Could you give an indication of the size of the database and the version of
SQL Server you using.
If you like although its not really recommended you can change the CPU's SQL
Server uses. You go to the properties of the Server under Enterprise Manager
then select Processors, just read up on BOL when you get there.
You could also check which jobs are running at the time, both continually
and at certain times, then have a look at optimising them.
However according to SQL Server 2000 Performance Tuning if the CPU usage is
greater than 80% then generally you need new processors.
"CC&JM" wrote:
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||Maybe these will help:
ut while DB expanding
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any
> way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||The biggest problem you have is to diagnose whether or not SQL Server is
performing legitimate work or not. If it is, then, as the others have
suggested, you are probably over capacity. If not, I would be suspecious
that you are being hit by a "slammer" like attack.
Here are some tests.
Block UDP port 1434 from the IPSec policies on the connecting
switch/firewall or SQL Server host itself. If the acitivity drops, you were
either being attacked, or legitimate clients have now all been locked out.
Take a look at SQLServer:Databases Transactions per Second and
SQLServer:Statistics Batch Requests per Second. This will tell you how much
activity is being thrown at the server.
Check the ProcessorTime% and PageFaults/sec for the sqlservr process. If
SQL Server is page faulting, you are probably shy on memory. You say you
have 4 GB of ram, but how are you using it? Have you enabled 4 GB Tuning?
Do you have SS2K Standard or Enterprise Edition. If EE, have you enabled
AWE or considered going multi-instanced?
What build level are you running? There was a MS security patch for SP2,
which was rolled up into SP3. There is also a post SP3a (build 760)
security patch, MS03-031 (builds 818 and 819). Finally, the most recent
publicly available hot fix is build 878.
First make sure you are not "infected," then I would concentrate on the
performance tuning and capacity planning.
Sincerely,
Anthony Thomas
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.Unfortunatly there is not a straight answer for your query.
My first question is are you sure its SQL Server that causing it, i.e. have
you looked into TASK MANAGER to see what process has the most CPU time ?
You could also set up a Performance check under Administration Tool, you can
set up CPU as one of the things it check.
Could you give an indication of the size of the database and the version of
SQL Server you using.
If you like although its not really recommended you can change the CPU's SQL
Server uses. You go to the properties of the Server under Enterprise Manager
then select Processors, just read up on BOL when you get there.
You could also check which jobs are running at the time, both continually
and at certain times, then have a look at optimising them.
However according to SQL Server 2000 Performance Tuning if the CPU usage is
greater than 80% then generally you need new processors.
"CC&JM" wrote:
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||Maybe these will help:
ut while DB expanding
http://www.microsoft.com/sql/techinfo/administration/2000/perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.com/sql_server_performance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.com/best_sql_server_performance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/adminsql/ad_perfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any
> way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||The biggest problem you have is to diagnose whether or not SQL Server is
performing legitimate work or not. If it is, then, as the others have
suggested, you are probably over capacity. If not, I would be suspecious
that you are being hit by a "slammer" like attack.
Here are some tests.
Block UDP port 1434 from the IPSec policies on the connecting
switch/firewall or SQL Server host itself. If the acitivity drops, you were
either being attacked, or legitimate clients have now all been locked out.
Take a look at SQLServer:Databases Transactions per Second and
SQLServer:Statistics Batch Requests per Second. This will tell you how much
activity is being thrown at the server.
Check the ProcessorTime% and PageFaults/sec for the sqlservr process. If
SQL Server is page faulting, you are probably shy on memory. You say you
have 4 GB of ram, but how are you using it? Have you enabled 4 GB Tuning?
Do you have SS2K Standard or Enterprise Edition. If EE, have you enabled
AWE or considered going multi-instanced?
What build level are you running? There was a MS security patch for SP2,
which was rolled up into SP3. There is also a post SP3a (build 760)
security patch, MS03-031 (builds 818 and 819). Finally, the most recent
publicly available hot fix is build 878.
First make sure you are not "infected," then I would concentrate on the
performance tuning and capacity planning.
Sincerely,
Anthony Thomas
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
CPU and MEMORY usage
Can some one tell me where can I get the CPU and Memory Usage of my server on the Sql Tables or a script or store proc that i could run to get the above. I need that and to store its results in history to show how are our servers perfomingexecute sp_who2 active
this will tell you whos is on your db and how much cpu (CPUTime) and mem (DISKIO) each user is taking
Cheers|||Actually gives the user activity accross the server you run it on. Not just the db activity - Sorry|||should use Performance Mointor to assess your server activity over a period of time.
you can log this info in .csv then import into SQL Server
have a look at :
www.sql-server-performance.com/performance_monitor_tips.asp
cheers|||On sp_who2 does the CPUTime equals to the CPU usage on the task manager and what about the Memory because i also want this memory to be the same as the one on the Task Manager|||Not sure about that. I think cputime that a sp_who will show the diskIO for each user and system query that occurs at the time of the SP execution. This does not take into consideration the O/S resources getting used.
I guess you could find out how much mem is allocated to SQL by looking at the properties of the server (right click on the server in Enterprise Manger) . From this figure you can work out how much resources are getting used in terms of how much mem has been allocated to SQL Server.
Cheers|||I 100% agree with you when you say we can manually look at properties and again on the task manager properties, the thing is we want a script that will do this for us automatically every hour to check the memory and cpu usage.|||Use performance mointor as it is the easiest way to shedule.
Look over the link above to see what counters you want to look at.
i.e Memory -- Pages/Sec, Memory Manager -- Total Server Memory (KB)
etc
What you could do is shedule it to output a csv file on the hour then set up a dts task to import this into SQL Server for anyalsis.
Once you know how much mem you allocated to SQL Server then you have constant that you can do calculations with.
Cheers|||Thanks, I think this will work perfect
this will tell you whos is on your db and how much cpu (CPUTime) and mem (DISKIO) each user is taking
Cheers|||Actually gives the user activity accross the server you run it on. Not just the db activity - Sorry|||should use Performance Mointor to assess your server activity over a period of time.
you can log this info in .csv then import into SQL Server
have a look at :
www.sql-server-performance.com/performance_monitor_tips.asp
cheers|||On sp_who2 does the CPUTime equals to the CPU usage on the task manager and what about the Memory because i also want this memory to be the same as the one on the Task Manager|||Not sure about that. I think cputime that a sp_who will show the diskIO for each user and system query that occurs at the time of the SP execution. This does not take into consideration the O/S resources getting used.
I guess you could find out how much mem is allocated to SQL by looking at the properties of the server (right click on the server in Enterprise Manger) . From this figure you can work out how much resources are getting used in terms of how much mem has been allocated to SQL Server.
Cheers|||I 100% agree with you when you say we can manually look at properties and again on the task manager properties, the thing is we want a script that will do this for us automatically every hour to check the memory and cpu usage.|||Use performance mointor as it is the easiest way to shedule.
Look over the link above to see what counters you want to look at.
i.e Memory -- Pages/Sec, Memory Manager -- Total Server Memory (KB)
etc
What you could do is shedule it to output a csv file on the hour then set up a dts task to import this into SQL Server for anyalsis.
Once you know how much mem you allocated to SQL Server then you have constant that you can do calculations with.
Cheers|||Thanks, I think this will work perfect
CPU and memory usage
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
Unfortunatly there is not a straight answer for your query.
My first question is are you sure its SQL Server that causing it, i.e. have
you looked into TASK MANAGER to see what process has the most CPU time ?
You could also set up a Performance check under Administration Tool, you can
set up CPU as one of the things it check.
Could you give an indication of the size of the database and the version of
SQL Server you using.
If you like although its not really recommended you can change the CPU's SQL
Server uses. You go to the properties of the Server under Enterprise Manager
then select Processors, just read up on BOL when you get there.
You could also check which jobs are running at the time, both continually
and at certain times, then have a look at optimising them.
However according to SQL Server 2000 Performance Tuning if the CPU usage is
greater than 80% then generally you need new processors.
"CC&JM" wrote:
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>
|||Maybe these will help:
ut while DB expanding
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any
> way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>
|||The biggest problem you have is to diagnose whether or not SQL Server is
performing legitimate work or not. If it is, then, as the others have
suggested, you are probably over capacity. If not, I would be suspecious
that you are being hit by a "slammer" like attack.
Here are some tests.
Block UDP port 1434 from the IPSec policies on the connecting
switch/firewall or SQL Server host itself. If the acitivity drops, you were
either being attacked, or legitimate clients have now all been locked out.
Take a look at SQLServer:Databases Transactions per Second and
SQLServer:Statistics Batch Requests per Second. This will tell you how much
activity is being thrown at the server.
Check the ProcessorTime% and PageFaults/sec for the sqlservr process. If
SQL Server is page faulting, you are probably shy on memory. You say you
have 4 GB of ram, but how are you using it? Have you enabled 4 GB Tuning?
Do you have SS2K Standard or Enterprise Edition. If EE, have you enabled
AWE or considered going multi-instanced?
What build level are you running? There was a MS security patch for SP2,
which was rolled up into SP3. There is also a post SP3a (build 760)
security patch, MS03-031 (builds 818 and 819). Finally, the most recent
publicly available hot fix is build 878.
First make sure you are not "infected," then I would concentrate on the
performance tuning and capacity planning.
Sincerely,
Anthony Thomas
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
Unfortunatly there is not a straight answer for your query.
My first question is are you sure its SQL Server that causing it, i.e. have
you looked into TASK MANAGER to see what process has the most CPU time ?
You could also set up a Performance check under Administration Tool, you can
set up CPU as one of the things it check.
Could you give an indication of the size of the database and the version of
SQL Server you using.
If you like although its not really recommended you can change the CPU's SQL
Server uses. You go to the properties of the Server under Enterprise Manager
then select Processors, just read up on BOL when you get there.
You could also check which jobs are running at the time, both continually
and at certain times, then have a look at optimising them.
However according to SQL Server 2000 Performance Tuning if the CPU usage is
greater than 80% then generally you need new processors.
"CC&JM" wrote:
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>
|||Maybe these will help:
ut while DB expanding
http://www.microsoft.com/sql/techinf...perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.co...ance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.co...mance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/de...rfmon_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any
> way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>
|||The biggest problem you have is to diagnose whether or not SQL Server is
performing legitimate work or not. If it is, then, as the others have
suggested, you are probably over capacity. If not, I would be suspecious
that you are being hit by a "slammer" like attack.
Here are some tests.
Block UDP port 1434 from the IPSec policies on the connecting
switch/firewall or SQL Server host itself. If the acitivity drops, you were
either being attacked, or legitimate clients have now all been locked out.
Take a look at SQLServer:Databases Transactions per Second and
SQLServer:Statistics Batch Requests per Second. This will tell you how much
activity is being thrown at the server.
Check the ProcessorTime% and PageFaults/sec for the sqlservr process. If
SQL Server is page faulting, you are probably shy on memory. You say you
have 4 GB of ram, but how are you using it? Have you enabled 4 GB Tuning?
Do you have SS2K Standard or Enterprise Edition. If EE, have you enabled
AWE or considered going multi-instanced?
What build level are you running? There was a MS security patch for SP2,
which was rolled up into SP3. There is also a post SP3a (build 760)
security patch, MS03-031 (builds 818 and 819). Finally, the most recent
publicly available hot fix is build 878.
First make sure you are not "infected," then I would concentrate on the
performance tuning and capacity planning.
Sincerely,
Anthony Thomas
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
CPU and memory usage
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.Unfortunatly there is not a straight answer for your query.
My first question is are you sure its SQL Server that causing it, i.e. have
you looked into TASK MANAGER to see what process has the most CPU time ?
You could also set up a Performance check under Administration Tool, you can
set up CPU as one of the things it check.
Could you give an indication of the size of the database and the version of
SQL Server you using.
If you like although its not really recommended you can change the CPU's SQL
Server uses. You go to the properties of the Server under Enterprise Manager
then select Processors, just read up on BOL when you get there.
You could also check which jobs are running at the time, both continually
and at certain times, then have a look at optimising them.
However according to SQL Server 2000 Performance Tuning if the CPU usage is
greater than 80% then generally you need new processors.
"CC&JM" wrote:
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any w
ay
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||Maybe these will help:
ut while DB expanding
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any
> way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||The biggest problem you have is to diagnose whether or not SQL Server is
performing legitimate work or not. If it is, then, as the others have
suggested, you are probably over capacity. If not, I would be suspecious
that you are being hit by a "slammer" like attack.
Here are some tests.
Block UDP port 1434 from the IPSec policies on the connecting
switch/firewall or SQL Server host itself. If the acitivity drops, you were
either being attacked, or legitimate clients have now all been locked out.
Take a look at SQLServer:Databases Transactions per Second and
SQLServer:Statistics Batch Requests per Second. This will tell you how much
activity is being thrown at the server.
Check the ProcessorTime% and PageFaults/sec for the sqlservr process. If
SQL Server is page faulting, you are probably shy on memory. You say you
have 4 GB of ram, but how are you using it? Have you enabled 4 GB Tuning?
Do you have SS2K Standard or Enterprise Edition. If EE, have you enabled
AWE or considered going multi-instanced?
What build level are you running? There was a MS security patch for SP2,
which was rolled up into SP3. There is also a post SP3a (build 760)
security patch, MS03-031 (builds 818 and 819). Finally, the most recent
publicly available hot fix is build 878.
First make sure you are not "infected," then I would concentrate on the
performance tuning and capacity planning.
Sincerely,
Anthony Thomas
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.Unfortunatly there is not a straight answer for your query.
My first question is are you sure its SQL Server that causing it, i.e. have
you looked into TASK MANAGER to see what process has the most CPU time ?
You could also set up a Performance check under Administration Tool, you can
set up CPU as one of the things it check.
Could you give an indication of the size of the database and the version of
SQL Server you using.
If you like although its not really recommended you can change the CPU's SQL
Server uses. You go to the properties of the Server under Enterprise Manager
then select Processors, just read up on BOL when you get there.
You could also check which jobs are running at the time, both continually
and at certain times, then have a look at optimising them.
However according to SQL Server 2000 Performance Tuning if the CPU usage is
greater than 80% then generally you need new processors.
"CC&JM" wrote:
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any w
ay
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||Maybe these will help:
ut while DB expanding
http://www.microsoft.com/sql/techin.../perftuning.asp
Performance WP's
http://www.swynk.com/friends/vandenberg/perfmonitor.asp Perfmon counters
http://www.sql-server-performance.c...mance_audit.asp
Hardware Performance CheckList
http://www.sql-server-performance.c...rmance_tips.asp
SQL 2000 Performance tuning tips
http://www.support.microsoft.com/?id=q224587 Troubleshooting App
Performance
http://msdn.microsoft.com/library/d.../>
on_24u1.asp
Disk Monitoring
Andrew J. Kelly SQL MVP
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
> Hello,
> I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
> currently consuming these CPU's and i cannot detect what is
> affecting(degreeding performance) so much SQL Server.
> Where should i need to start troubleshooting my bottleneck? Is there any
> way
> or free tool that i can use without affecting my system?
> Thanks and best regards.
>|||The biggest problem you have is to diagnose whether or not SQL Server is
performing legitimate work or not. If it is, then, as the others have
suggested, you are probably over capacity. If not, I would be suspecious
that you are being hit by a "slammer" like attack.
Here are some tests.
Block UDP port 1434 from the IPSec policies on the connecting
switch/firewall or SQL Server host itself. If the acitivity drops, you were
either being attacked, or legitimate clients have now all been locked out.
Take a look at SQLServer:Databases Transactions per Second and
SQLServer:Statistics Batch Requests per Second. This will tell you how much
activity is being thrown at the server.
Check the ProcessorTime% and PageFaults/sec for the sqlservr process. If
SQL Server is page faulting, you are probably shy on memory. You say you
have 4 GB of ram, but how are you using it? Have you enabled 4 GB Tuning?
Do you have SS2K Standard or Enterprise Edition. If EE, have you enabled
AWE or considered going multi-instanced?
What build level are you running? There was a MS security patch for SP2,
which was rolled up into SP3. There is also a post SP3a (build 760)
security patch, MS03-031 (builds 818 and 819). Finally, the most recent
publicly available hot fix is build 878.
First make sure you are not "infected," then I would concentrate on the
performance tuning and capacity planning.
Sincerely,
Anthony Thomas
"CC&JM" <CCJM@.discussions.microsoft.com> wrote in message
news:7D64EBA4-A145-4BF0-A420-84E1E6D1BE50@.microsoft.com...
Hello,
I have one database server, with 4 CPUs and 4GB of RAM, SQL Server is
currently consuming these CPU's and i cannot detect what is
affecting(degreeding performance) so much SQL Server.
Where should i need to start troubleshooting my bottleneck? Is there any way
or free tool that i can use without affecting my system?
Thanks and best regards.
CPU and Memory counters
Hi,
Id like to collect some information about SQL server itself like "% of CPU
Usage" or "% of memory usage".
Something like SELECT @.@.CPU_Usage ...... ?
Thanks,
Tim.Use Performance Monitor. You can set it up to record automagically on
specific schedules/durations/frequencies as well as choosing your
objects/counters.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Tim Xox" <timur@.mtgsi.com> wrote in message
news:uMl%23e98oDHA.1708@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Id like to collect some information about SQL server itself like "% of CPU
> Usage" or "% of memory usage".
> Something like SELECT @.@.CPU_Usage ...... ?
> Thanks,
> Tim.
>|||Thank you, Geoff,
problem is - I need this counter into me SELECT statement to put it in a
table.
Any idea?
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uufC%23T9oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> Use Performance Monitor. You can set it up to record automagically on
> specific schedules/durations/frequencies as well as choosing your
> objects/counters.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Tim Xox" <timur@.mtgsi.com> wrote in message
> news:uMl%23e98oDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > Id like to collect some information about SQL server itself like "% of
CPU
> > Usage" or "% of memory usage".
> > Something like SELECT @.@.CPU_Usage ...... ?
> > Thanks,
> > Tim.
> >
> >
>|||Take a look at the sysperfinfo table.
--
Andrew J. Kelly
SQL Server MVP
"Tim Xox" <timur@.mtgsi.com> wrote in message
news:uZfayn9oDHA.488@.tk2msftngp13.phx.gbl...
> Thank you, Geoff,
> problem is - I need this counter into me SELECT statement to put it in a
> table.
> Any idea?
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uufC%23T9oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > Use Performance Monitor. You can set it up to record automagically on
> > specific schedules/durations/frequencies as well as choosing your
> > objects/counters.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> > "Tim Xox" <timur@.mtgsi.com> wrote in message
> > news:uMl%23e98oDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > > Id like to collect some information about SQL server itself like "% of
> CPU
> > > Usage" or "% of memory usage".
> > > Something like SELECT @.@.CPU_Usage ...... ?
> > > Thanks,
> > > Tim.
> > >
> > >
> >
> >
>
Id like to collect some information about SQL server itself like "% of CPU
Usage" or "% of memory usage".
Something like SELECT @.@.CPU_Usage ...... ?
Thanks,
Tim.Use Performance Monitor. You can set it up to record automagically on
specific schedules/durations/frequencies as well as choosing your
objects/counters.
--
Geoff N. Hiten
Microsoft SQL Server MVP
Senior Database Administrator
Careerbuilder.com
"Tim Xox" <timur@.mtgsi.com> wrote in message
news:uMl%23e98oDHA.1708@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Id like to collect some information about SQL server itself like "% of CPU
> Usage" or "% of memory usage".
> Something like SELECT @.@.CPU_Usage ...... ?
> Thanks,
> Tim.
>|||Thank you, Geoff,
problem is - I need this counter into me SELECT statement to put it in a
table.
Any idea?
"Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
news:uufC%23T9oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> Use Performance Monitor. You can set it up to record automagically on
> specific schedules/durations/frequencies as well as choosing your
> objects/counters.
> --
> Geoff N. Hiten
> Microsoft SQL Server MVP
> Senior Database Administrator
> Careerbuilder.com
>
> "Tim Xox" <timur@.mtgsi.com> wrote in message
> news:uMl%23e98oDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > Hi,
> > Id like to collect some information about SQL server itself like "% of
CPU
> > Usage" or "% of memory usage".
> > Something like SELECT @.@.CPU_Usage ...... ?
> > Thanks,
> > Tim.
> >
> >
>|||Take a look at the sysperfinfo table.
--
Andrew J. Kelly
SQL Server MVP
"Tim Xox" <timur@.mtgsi.com> wrote in message
news:uZfayn9oDHA.488@.tk2msftngp13.phx.gbl...
> Thank you, Geoff,
> problem is - I need this counter into me SELECT statement to put it in a
> table.
> Any idea?
>
> "Geoff N. Hiten" <SRDBA@.Careerbuilder.com> wrote in message
> news:uufC%23T9oDHA.1740@.TK2MSFTNGP12.phx.gbl...
> > Use Performance Monitor. You can set it up to record automagically on
> > specific schedules/durations/frequencies as well as choosing your
> > objects/counters.
> >
> > --
> > Geoff N. Hiten
> > Microsoft SQL Server MVP
> > Senior Database Administrator
> > Careerbuilder.com
> >
> >
> > "Tim Xox" <timur@.mtgsi.com> wrote in message
> > news:uMl%23e98oDHA.1708@.TK2MSFTNGP12.phx.gbl...
> > > Hi,
> > > Id like to collect some information about SQL server itself like "% of
> CPU
> > > Usage" or "% of memory usage".
> > > Something like SELECT @.@.CPU_Usage ...... ?
> > > Thanks,
> > > Tim.
> > >
> > >
> >
> >
>
CPU and I/O affinity config
I have 8 Processors and 12 GB memory box, I want to install two production
SQl Server 2005
instances on this box. Please advise what is the correct seeting to set these
processor affinity and i/0 affinity.
I am planning to assaign 4 CPu for one instace and 3 instances for another
instance.
My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
how to achive this?
4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
mask 2,3 for i/o affinity mask.
Please give some advise or related articleas on this how to do configure.
--
SQL serer DBAHi
According to http://msdn2.microsoft.com/en-us/library/ms189629(SQL.90).aspx
"When specifying the affinity I/O mask option, you must use it with the
affinity mask configuration option. Do not enable the same CPU in both the
affinity I/O mask switch and the affinity mask option"
John
"Srikanth" wrote:
> I have 8 Processors and 12 GB memory box, I want to install two production
> SQl Server 2005
> instances on this box. Please advise what is the correct seeting to set these
> processor affinity and i/0 affinity.
> I am planning to assaign 4 CPu for one instace and 3 instances for another
> instance.
> My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
> how to achive this?
> 4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
> CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
> mask 2,3 for i/o affinity mask.
> Please give some advise or related articleas on this how to do configure.
>
> --
> SQL serer DBA
SQl Server 2005
instances on this box. Please advise what is the correct seeting to set these
processor affinity and i/0 affinity.
I am planning to assaign 4 CPu for one instace and 3 instances for another
instance.
My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
how to achive this?
4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
mask 2,3 for i/o affinity mask.
Please give some advise or related articleas on this how to do configure.
--
SQL serer DBAHi
According to http://msdn2.microsoft.com/en-us/library/ms189629(SQL.90).aspx
"When specifying the affinity I/O mask option, you must use it with the
affinity mask configuration option. Do not enable the same CPU in both the
affinity I/O mask switch and the affinity mask option"
John
"Srikanth" wrote:
> I have 8 Processors and 12 GB memory box, I want to install two production
> SQl Server 2005
> instances on this box. Please advise what is the correct seeting to set these
> processor affinity and i/0 affinity.
> I am planning to assaign 4 CPu for one instace and 3 instances for another
> instance.
> My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
> how to achive this?
> 4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
> CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
> mask 2,3 for i/o affinity mask.
> Please give some advise or related articleas on this how to do configure.
>
> --
> SQL serer DBA
CPU and I/O affinity config
I have 8 Processors and 12 GB memory box, I want to install two production
SQl Server 2005
instances on this box. Please advise what is the correct seeting to set thes
e
processor affinity and i/0 affinity.
I am planning to assaign 4 CPu for one instace and 3 instances for another
instance.
My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
how to achive this?
4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
mask 2,3 for i/o affinity mask.
Please give some advise or related articleas on this how to do configure.
SQL serer DBAHi
According to http://msdn2.microsoft.com/en-us/library/ms189629(SQL.90).aspx
"When specifying the affinity I/O mask option, you must use it with the
affinity mask configuration option. Do not enable the same CPU in both the
affinity I/O mask switch and the affinity mask option"
John
"Srikanth" wrote:
> I have 8 Processors and 12 GB memory box, I want to install two production
> SQl Server 2005
> instances on this box. Please advise what is the correct seeting to set th
ese
> processor affinity and i/0 affinity.
> I am planning to assaign 4 CPu for one instace and 3 instances for another
> instance.
> My confusion is i need to use same CPUs for CPU affinity and i/o affinity
or
> how to achive this?
> 4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 u
se
> CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
> mask 2,3 for i/o affinity mask.
> Please give some advise or related articleas on this how to do configure.
>
> --
> SQL serer DBA
SQl Server 2005
instances on this box. Please advise what is the correct seeting to set thes
e
processor affinity and i/0 affinity.
I am planning to assaign 4 CPu for one instace and 3 instances for another
instance.
My confusion is i need to use same CPUs for CPU affinity and i/o affinity or
how to achive this?
4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 use
CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
mask 2,3 for i/o affinity mask.
Please give some advise or related articleas on this how to do configure.
SQL serer DBAHi
According to http://msdn2.microsoft.com/en-us/library/ms189629(SQL.90).aspx
"When specifying the affinity I/O mask option, you must use it with the
affinity mask configuration option. Do not enable the same CPU in both the
affinity I/O mask switch and the affinity mask option"
John
"Srikanth" wrote:
> I have 8 Processors and 12 GB memory box, I want to install two production
> SQl Server 2005
> instances on this box. Please advise what is the correct seeting to set th
ese
> processor affinity and i/0 affinity.
> I am planning to assaign 4 CPu for one instace and 3 instances for another
> instance.
> My confusion is i need to use same CPUs for CPU affinity and i/o affinity
or
> how to achive this?
> 4 CPU for one instanec - 0,1,2,3. here confusion i need to check 0,1,2,3 u
se
> CPY affinitymask and 0,1,2,3 to i/o affinity mask or 0,1 for CPU affinity
> mask 2,3 for i/o affinity mask.
> Please give some advise or related articleas on this how to do configure.
>
> --
> SQL serer DBA
cpu & memory usage on large, long-running query
Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
Loane
If you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:
>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>
|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
Loane
If you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:
>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>
|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
cpu & memory usage on large, long-running query
Hi there
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
LoaneIf you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:
>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.
4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
>
I'm not a SQL Server developer or power-user, mostly I do statistical and
similar analysis on large datasets and use SQL Server to manage the
underlying data.
I notice that, on my IBM workstation, my CPU utilization doesn't rise much
above 50% and my PF usage doesn't rise above 40% on large, long-running
queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
Can I whip up the speed a bit, or if not what's the limiting factor?
Best regards
LoaneIf you aren't hitting any resource bottlenecks then look at
the execution plan for the queries and work on tuning the
queries themselves. One of the biggest factors will be use
of indexes. You can find a lot of information on performance
tuning at:
http://www.sql-server-performance.com/
-Sue
On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
<look_sharp_not@.hotmail.com> wrote:
>Hi there
>I'm not a SQL Server developer or power-user, mostly I do statistical and
>similar analysis on large datasets and use SQL Server to manage the
>underlying data.
>I notice that, on my IBM workstation, my CPU utilization doesn't rise much
>above 50% and my PF usage doesn't rise above 40% on large, long-running
>queries. I have a 3.4GHz Intel P4 processor with 1.25GB of RAM.
>Can I whip up the speed a bit, or if not what's the limiting factor?
>Best regards
>Loane
>|||Thanks Sue, will press on ...
"Sue Hoegemeier" <Sue_H@.nomail.please> wrote in message
news:b2uk81lvrq2ekiq8fvgeug1f40ujnq5em9@.
4ax.com...
> If you aren't hitting any resource bottlenecks then look at
> the execution plan for the queries and work on tuning the
> queries themselves. One of the biggest factors will be use
> of indexes. You can find a lot of information on performance
> tuning at:
> http://www.sql-server-performance.com/
> -Sue
> On Tue, 17 May 2005 19:59:57 +0200, "Loane Sharp"
> <look_sharp_not@.hotmail.com> wrote:
>
>
Subscribe to:
Posts (Atom)