A Dimension Attribute with Double DataType converts a zero member to "(blank)"

In one of our SSAS 2005 sp2 cubes, we have a Dimension sourced from an Oracle table, with an Attribute that has a DataType of Double. When we process the Dimension and browse the Attribute, we see the following members:

All

-.01

-.002

.00000000001

.0000000001

Unknown

Notice how its blank where the '0' (zero) member should be. The underlying Oracle table does have '0' (zero) values for this column (you can see them when you explore the data in the DSV). To make things even more confusing,

the Unique_Name for this blank member is: [Dimension].[Attribute].&[0]

its Member_Value is: 0

its Member_Caption is: Null

its Member_Key is: 0

Has anyone seen this behaviour before? If so, how do we fix it?

Thank you.

Hi,

Have you set the NameColumn to look at the same field? And is it a datatype of WChar?

Matt|||

Hi Matt,

Thanks for the reply. Yes, setting the NameColumn to the field was one of the things i tried. The database field is NUMERIC(15,9), the KeyColumn is a datatype of Double and the NameColumn is a datatype of WChar. Even with the NameColumn set to the same field, I still get a blank where the 0 value should be.

-Robbie

a connection could not be made to the data source

I am trying to process a cube still it failed since "Errors in the high-level relational engine. A connection could not be made to the data source with the DataSource of "MY-DATASOURCE", Name of "MY-DATASOURCE").

The sql instance is running on the same machine in where I am working the solution. Can someone provide some hints on what to do to resolve this issue?

By looking at the "AdventuresWorks" sample the main difference that I have in my solution is that I have an instance and the AW sample is pointing to the default instance using the "localhost" reference only. My datasource connection is refered as "MyHost\MySqlInstance"...
I used the wong impersonation settings! I changed those and now I am processing the cube.

A Clarification required on xp_terminate_process

HI ,

I have a problem where i have to kill a windows process in my procedure. In sql server 2000 i could find a procedure called xp_terminate_process ( which takes process id as parmeter and kills the process) . but i couldnt find any replacement or another new one to do the same in sql server 2005. if any body have any idea or suggestion regarding how to go about this are welcome..

Thanks in advance

Mohan

I just can't imagine task required Windows process killing on database server. Could you please tell us?|||

it will be some thing like ,

i have created a package and scheduled it to run , then when it executes it will create a dtshost.exe process.i ll capturing this process id and store it . and i have some data where i can know if any job exceeds its time of excution (for eg: schduled for 10 minutes but running for 20 minutes). we can do this scheduling by using sqlserver agent. but i ll be using some other mechanism where i can control the concurrency of executions. there i ll have procedure whihch will run periodically and checks that if any job is timedout , then get the process id of that job and kill the process.

This is what my requirement is ...

thanks and Regards

Krishna Kishore

|||Maybe it would be enough just to kill sql server connection made by dtshost.exe ( using simple KILL command ) ?|||

i dont think there will be n number of connections to the n number of servers in my package ,i can not determine which connection i need to terminate. so i think kill is not sifficient. by using xp_terminate_process you can kill the entire process...

but it s not available in the sql server 2005 ? what should i do any alternate for this...

Thanks in advance

krishna Kishore

|||

Hi Krishna,

Have u used xp_terminate_procces in SQL Server 2000?, as i m using it but it doesnt seems to terminate the process, not even showing any error. I m using the following query:

exec master..xp_terminate_process <pid>

When i execute, it just says the command completed successfully....

but the process is no killed :(

Plz reply me, if u have any idea whats wrong with the query or if i m not using it correctly..

Thanks and Regards,

|||

Hi ,

you have not given your requirement clearly? But i XP_terminate_process can kill any kind of process, have you checked whether your are referring to correct pid or not?

if you still feel it's not working use xp_cmdshell to kill the proces by using a command argument

the command is taskkill

taskkill /f /pid 1234 where pid is 1234

Thanks

Krishna

|||

I m using xp_terminate_process with a correct processid, but the command is not terminating the process.(I know that its an undocumented procedure, so its not guaranteed to work). I just wanted to know if u have used xp_terminate_process successfully?

I have sqlserver 2000 with sp4. I m using the following statement.

exec master..xp_terminate_process 3254

(Here 3254 is the process id for cmd.exe, i wish to terminate)

I know about cmdshell and kill/taskkill but i dont want to use cmdshell for some reason.

Thanks for ur reply.

A Clarification required on xp_terminate_process

HI ,

I have a problem where i have to kill a windows process in my procedure. In sql server 2000 i could find a procedure called xp_terminate_process ( which takes process id as parmeter and kills the process) . but i couldnt find any replacement or another new one to do the same in sql server 2005. if any body have any idea or suggestion regarding how to go about this are welcome..

Thanks in advance

Mohan

I just can't imagine task required Windows process killing on database server. Could you please tell us?|||

it will be some thing like ,

i have created a package and scheduled it to run , then when it executes it will create a dtshost.exe process.i ll capturing this process id and store it . and i have some data where i can know if any job exceeds its time of excution (for eg: schduled for 10 minutes but running for 20 minutes). we can do this scheduling by using sqlserver agent. but i ll be using some other mechanism where i can control the concurrency of executions. there i ll have procedure whihch will run periodically and checks that if any job is timedout , then get the process id of that job and kill the process.

This is what my requirement is ...

thanks and Regards

Krishna Kishore

|||Maybe it would be enough just to kill sql server connection made by dtshost.exe ( using simple KILL command ) ?|||

i dont think there will be n number of connections to the n number of servers in my package ,i can not determine which connection i need to terminate. so i think kill is not sifficient. by using xp_terminate_process you can kill the entire process...

but it s not available in the sql server 2005 ? what should i do any alternate for this...

Thanks in advance

krishna Kishore

|||

Hi Krishna,

Have u used xp_terminate_procces in SQL Server 2000?, as i m using it but it doesnt seems to terminate the process, not even showing any error. I m using the following query:

exec master..xp_terminate_process <pid>

When i execute, it just says the command completed successfully....

but the process is no killed :(

Plz reply me, if u have any idea whats wrong with the query or if i m not using it correctly..

Thanks and Regards,

|||

Hi ,

you have not given your requirement clearly? But i XP_terminate_process can kill any kind of process, have you checked whether your are referring to correct pid or not?

if you still feel it's not working use xp_cmdshell to kill the proces by using a command argument

the command is taskkill

taskkill /f /pid 1234 where pid is 1234

Thanks

Krishna

|||

I m using xp_terminate_process with a correct processid, but the command is not terminating the process.(I know that its an undocumented procedure, so its not guaranteed to work). I just wanted to know if u have used xp_terminate_process successfully?

I have sqlserver 2000 with sp4. I m using the following statement.

exec master..xp_terminate_process 3254

(Here 3254 is the process id for cmd.exe, i wish to terminate)

I know about cmdshell and kill/taskkill but i dont want to use cmdshell for some reason.

Thanks for ur reply.

823 Error after the DB recovery

I just backup an ArcSDE geography database in SQL Server 2000, whose size is
about 3.5GB. The backup process was finished and checked properly, but when
it has been recovered, some errors occur:
First, when you click the data table in the enterprise manager window,
choose the design item in the right button menu, an error window come to
show: "823" and nothing. And if you choose to see all lines in the table,
you will find some data of the table has disappeared. In other words, data
recovery was not successful, but why no error in the whole process?
Second, if you click some table occasionally, it alerts: The data base has
not been connected.
Third, you can't get connection to the database in any way.
I wonder if there was something wrong underlying, our goal is to move the
database from their machine to ours, and the software environment (I mean
the SQL Server version) is totally the same. Nonetheless, we can not assure
some login users' consistence, which we are going to solve after the
recovery, but we don't take it as the critical reason for the fault.
Therefore, if some veteran in this field can offer some help, I really
appreciate.
Thanks in advance.
error 823 is I/O error %ls detected during %S_MSG at offset %#016I64x in
file '%ls'.
Do you get an error like this or merely 823? What happens when you do a dbcc
checkalloc in this database?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Alex Dai" <alexdaichn@.hotmail.com> wrote in message
news:%235b1J6WVFHA.4056@.TK2MSFTNGP15.phx.gbl...
> I just backup an ArcSDE geography database in SQL Server 2000, whose size
is
> about 3.5GB. The backup process was finished and checked properly, but
when
> it has been recovered, some errors occur:
> First, when you click the data table in the enterprise manager window,
> choose the design item in the right button menu, an error window come to
> show: "823" and nothing. And if you choose to see all lines in the table,
> you will find some data of the table has disappeared. In other words, data
> recovery was not successful, but why no error in the whole process?
> Second, if you click some table occasionally, it alerts: The data base has
> not been connected.
> Third, you can't get connection to the database in any way.
> I wonder if there was something wrong underlying, our goal is to move the
> database from their machine to ours, and the software environment (I mean
> the SQL Server version) is totally the same. Nonetheless, we can not
assure
> some login users' consistence, which we are going to solve after the
> recovery, but we don't take it as the critical reason for the fault.
> Therefore, if some veteran in this field can offer some help, I really
> appreciate.
> Thanks in advance.
>
|||Here I run DBCC CHECKDB('<mydb>', REPAIR_REBUILD), but it informs me the
database must be in single user mode, what's the problem?
"Hilary Cotter" <hilary.cotter@.gmail.com> д?
news:e$Xs42YVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> error 823 is I/O error %ls detected during %S_MSG at offset %#016I64x in
> file '%ls'.
> Do you get an error like this or merely 823? What happens when you do a
dbcc[vbcol=seagreen]
> checkalloc in this database?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Alex Dai" <alexdaichn@.hotmail.com> wrote in message
> news:%235b1J6WVFHA.4056@.TK2MSFTNGP15.phx.gbl...
size[vbcol=seagreen]
> is
> when
table,[vbcol=seagreen]
data[vbcol=seagreen]
has[vbcol=seagreen]
the[vbcol=seagreen]
mean
> assure
>
|||I have been waiting for this issue, somebody could help me out?
"Alex Dai" <alexdaichn@.hotmail.com> д?
news:ODg9OrdVFHA.3076@.TK2MSFTNGP10.phx.gbl...[vbcol=seagreen]
> Here I run DBCC CHECKDB('<mydb>', REPAIR_REBUILD), but it informs me the
> database must be in single user mode, what's the problem?
> "Hilary Cotter" <hilary.cotter@.gmail.com> д?
> news:e$Xs42YVFHA.3280@.TK2MSFTNGP09.phx.gbl...
> dbcc
> size
to
> table,
> data
> has
> the
> mean
>

4 processors, 8 Gigs RAM, 22 Seconds to process report?

I have a table report based on a single 50,000 row table. The report
doesn't do anything unusual, but there are 5 grouping levels. The
ExecutionLog table shows the report took < 1 second to pull the data,
but 22 seconds to process the report.
Given that my high end server can perform millions of calcs per
second, does anyone know why my report would take so long to process?
The error logs show nothing unusual.
Thanks,
BurtWhat format are you using? From the execution log, where is most of the time
spent, processing, rendering?
--
Tudor Trufinescu
Dev Lead
Sql Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Burt" <burt_5920@.yahoo.com> wrote in message
news:19e5f39f.0408231024.4c58f3d@.posting.google.com...
> I have a table report based on a single 50,000 row table. The report
> doesn't do anything unusual, but there are 5 grouping levels. The
> ExecutionLog table shows the report took < 1 second to pull the data,
> but 22 seconds to process the report.
> Given that my high end server can perform millions of calcs per
> second, does anyone know why my report would take so long to process?
> The error logs show nothing unusual.
> Thanks,
> Burt|||Hi Tudor,
The format is HTML. Both rendering and the data pull from SQL Server
take less than a second. The report processing takes 22 seconds.
If I use an AS OLAP cube as the data source, the data pull takes 10
seconds, but the report still takes ~22 seconds to process.
Any thoughts?
Thanks,
Burt
"Tudor Trufinescu \(MSFT\)" <tudortr@.ms.com> wrote in message news:<#KushWViEHA.1512@.TK2MSFTNGP10.phx.gbl>...
> What format are you using? From the execution log, where is most of the time
> spent, processing, rendering?
> --
> Tudor Trufinescu
> Dev Lead
> Sql Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Burt" <burt_5920@.yahoo.com> wrote in message
> news:19e5f39f.0408231024.4c58f3d@.posting.google.com...
> > I have a table report based on a single 50,000 row table. The report
> > doesn't do anything unusual, but there are 5 grouping levels. The
> > ExecutionLog table shows the report took < 1 second to pull the data,
> > but 22 seconds to process the report.
> >
> > Given that my high end server can perform millions of calcs per
> > second, does anyone know why my report would take so long to process?
> > The error logs show nothing unusual.
> >
> > Thanks,
> >
> > Burt|||Just to make sure, are you using filters in your report? Filters bring over
all the data (in your case 50,000 rows) prior to doing anything with the
data. Then it works on the data (doing the filtering, grouping etc).
Bruce L-C
"Burt" <burt_5920@.yahoo.com> wrote in message
news:19e5f39f.0408240850.42e0d965@.posting.google.com...
> Hi Tudor,
> The format is HTML. Both rendering and the data pull from SQL Server
> take less than a second. The report processing takes 22 seconds.
> If I use an AS OLAP cube as the data source, the data pull takes 10
> seconds, but the report still takes ~22 seconds to process.
> Any thoughts?
> Thanks,
> Burt
>
> "Tudor Trufinescu \(MSFT\)" <tudortr@.ms.com> wrote in message
news:<#KushWViEHA.1512@.TK2MSFTNGP10.phx.gbl>...
> > What format are you using? From the execution log, where is most of the
time
> > spent, processing, rendering?
> >
> > --
> > Tudor Trufinescu
> > Dev Lead
> > Sql Server Reporting Services
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Burt" <burt_5920@.yahoo.com> wrote in message
> > news:19e5f39f.0408231024.4c58f3d@.posting.google.com...
> > > I have a table report based on a single 50,000 row table. The report
> > > doesn't do anything unusual, but there are 5 grouping levels. The
> > > ExecutionLog table shows the report took < 1 second to pull the data,
> > > but 22 seconds to process the report.
> > >
> > > Given that my high end server can perform millions of calcs per
> > > second, does anyone know why my report would take so long to process?
> > > The error logs show nothing unusual.
> > >
> > > Thanks,
> > >
> > > Burt|||Thanks, Bruce, but no, no filters. Some additional info:
-There are actually only 18K rows in the table, not 50K, and 6 groups,
not 5.
-A couple of guys on the RS dev team from MS were kind enough to take
a look at the rdl, but didn't spot anything unusual.
-I created a similar 6 group report in MS Access, which took only a
couple of seconds to create.
-I have a 600K zip file with the RDL, table DDL, and actual table data
if anyone wants to play with it.
Thanks,
Burt
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<O$OooBgiEHA.712@.TK2MSFTNGP09.phx.gbl>...
> Just to make sure, are you using filters in your report? Filters bring over
> all the data (in your case 50,000 rows) prior to doing anything with the
> data. Then it works on the data (doing the filtering, grouping etc).
> Bruce L-C
> "Burt" <burt_5920@.yahoo.com> wrote in message
> news:19e5f39f.0408240850.42e0d965@.posting.google.com...
> > Hi Tudor,
> >
> > The format is HTML. Both rendering and the data pull from SQL Server
> > take less than a second. The report processing takes 22 seconds.
> >
> > If I use an AS OLAP cube as the data source, the data pull takes 10
> > seconds, but the report still takes ~22 seconds to process.
> >
> > Any thoughts?
> >
> > Thanks,
> >
> > Burt
> >
> >
> > "Tudor Trufinescu \(MSFT\)" <tudortr@.ms.com> wrote in message
> news:<#KushWViEHA.1512@.TK2MSFTNGP10.phx.gbl>...
> > > What format are you using? From the execution log, where is most of the
> time
> > > spent, processing, rendering?
> > >
> > > --
> > > Tudor Trufinescu
> > > Dev Lead
> > > Sql Server Reporting Services
> > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > >
> > >
> > > "Burt" <burt_5920@.yahoo.com> wrote in message
> > > news:19e5f39f.0408231024.4c58f3d@.posting.google.com...
> > > > I have a table report based on a single 50,000 row table. The report
> > > > doesn't do anything unusual, but there are 5 grouping levels. The
> > > > ExecutionLog table shows the report took < 1 second to pull the data,
> > > > but 22 seconds to process the report.
> > > >
> > > > Given that my high end server can perform millions of calcs per
> > > > second, does anyone know why my report would take so long to process?
> > > > The error logs show nothing unusual.
> > > >
> > > > Thanks,
> > > >
> > > > Burt|||I don't think this would make a difference but how hard would it be to start
anew with the report. I have had issues where I have added a group, removed
it etc and everything did not remove from the rdl. Just grasping at straws
here. I would think MS would definitely be interested in what you have here.
Bruce L-C
"Burt" <burt_5920@.yahoo.com> wrote in message
news:19e5f39f.0408250907.43140876@.posting.google.com...
> Thanks, Bruce, but no, no filters. Some additional info:
> -There are actually only 18K rows in the table, not 50K, and 6 groups,
> not 5.
> -A couple of guys on the RS dev team from MS were kind enough to take
> a look at the rdl, but didn't spot anything unusual.
> -I created a similar 6 group report in MS Access, which took only a
> couple of seconds to create.
> -I have a 600K zip file with the RDL, table DDL, and actual table data
> if anyone wants to play with it.
> Thanks,
> Burt
>
>
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:<O$OooBgiEHA.712@.TK2MSFTNGP09.phx.gbl>...
> > Just to make sure, are you using filters in your report? Filters bring
over
> > all the data (in your case 50,000 rows) prior to doing anything with the
> > data. Then it works on the data (doing the filtering, grouping etc).
> >
> > Bruce L-C
> >
> > "Burt" <burt_5920@.yahoo.com> wrote in message
> > news:19e5f39f.0408240850.42e0d965@.posting.google.com...
> > > Hi Tudor,
> > >
> > > The format is HTML. Both rendering and the data pull from SQL Server
> > > take less than a second. The report processing takes 22 seconds.
> > >
> > > If I use an AS OLAP cube as the data source, the data pull takes 10
> > > seconds, but the report still takes ~22 seconds to process.
> > >
> > > Any thoughts?
> > >
> > > Thanks,
> > >
> > > Burt
> > >
> > >
> > > "Tudor Trufinescu \(MSFT\)" <tudortr@.ms.com> wrote in message
> > news:<#KushWViEHA.1512@.TK2MSFTNGP10.phx.gbl>...
> > > > What format are you using? From the execution log, where is most of
the
> > time
> > > > spent, processing, rendering?
> > > >
> > > > --
> > > > Tudor Trufinescu
> > > > Dev Lead
> > > > Sql Server Reporting Services
> > > > This posting is provided "AS IS" with no warranties, and confers no
> > rights.
> > > >
> > > >
> > > > "Burt" <burt_5920@.yahoo.com> wrote in message
> > > > news:19e5f39f.0408231024.4c58f3d@.posting.google.com...
> > > > > I have a table report based on a single 50,000 row table. The
report
> > > > > doesn't do anything unusual, but there are 5 grouping levels. The
> > > > > ExecutionLog table shows the report took < 1 second to pull the
data,
> > > > > but 22 seconds to process the report.
> > > > >
> > > > > Given that my high end server can perform millions of calcs per
> > > > > second, does anyone know why my report would take so long to
process?
> > > > > The error logs show nothing unusual.
> > > > >
> > > > > Thanks,
> > > > >
> > > > > Burt|||Thanks, Bruce. I've actually created a few versions of the report with
similar results.
Per MS, RS is taking a (session) snapshot of the report and saving it
as they process the report, this is the most time consuming part of
this particular report.
Something tells me as their engine matures these reports will get
faster...
Burt
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message news:<OjEnXBtiEHA.3972@.tk2msftngp13.phx.gbl>...
> I don't think this would make a difference but how hard would it be to start
> anew with the report. I have had issues where I have added a group, removed
> it etc and everything did not remove from the rdl. Just grasping at straws
> here. I would think MS would definitely be interested in what you have here.
> Bruce L-C
> "Burt" <burt_5920@.yahoo.com> wrote in message
> news:19e5f39f.0408250907.43140876@.posting.google.com...
> > Thanks, Bruce, but no, no filters. Some additional info:
> >
> > -There are actually only 18K rows in the table, not 50K, and 6 groups,
> > not 5.
> >
> > -A couple of guys on the RS dev team from MS were kind enough to take
> > a look at the rdl, but didn't spot anything unusual.
> >
> > -I created a similar 6 group report in MS Access, which took only a
> > couple of seconds to create.
> >
> > -I have a 600K zip file with the RDL, table DDL, and actual table data
> > if anyone wants to play with it.
> >
> > Thanks,
> >
> > Burt
> >
> >
> >
> >
> > "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:<O$OooBgiEHA.712@.TK2MSFTNGP09.phx.gbl>...
> > > Just to make sure, are you using filters in your report? Filters bring
> over
> > > all the data (in your case 50,000 rows) prior to doing anything with the
> > > data. Then it works on the data (doing the filtering, grouping etc).
> > >
> > > Bruce L-C
> > >
> > > "Burt" <burt_5920@.yahoo.com> wrote in message
> > > news:19e5f39f.0408240850.42e0d965@.posting.google.com...
> > > > Hi Tudor,
> > > >
> > > > The format is HTML. Both rendering and the data pull from SQL Server
> > > > take less than a second. The report processing takes 22 seconds.
> > > >
> > > > If I use an AS OLAP cube as the data source, the data pull takes 10
> > > > seconds, but the report still takes ~22 seconds to process.
> > > >
> > > > Any thoughts?
> > > >
> > > > Thanks,
> > > >
> > > > Burt
> > > >
> > > >
> > > > "Tudor Trufinescu \(MSFT\)" <tudortr@.ms.com> wrote in message
> news:<#KushWViEHA.1512@.TK2MSFTNGP10.phx.gbl>...
> > > > > What format are you using? From the execution log, where is most of
> the
> time
> > > > > spent, processing, rendering?
> > > > >
> > > > > --
> > > > > Tudor Trufinescu
> > > > > Dev Lead
> > > > > Sql Server Reporting Services
> > > > > This posting is provided "AS IS" with no warranties, and confers no
> rights.
> > > > >
> > > > >
> > > > > "Burt" <burt_5920@.yahoo.com> wrote in message
> > > > > news:19e5f39f.0408231024.4c58f3d@.posting.google.com...
> > > > > > I have a table report based on a single 50,000 row table. The
> report
> > > > > > doesn't do anything unusual, but there are 5 grouping levels. The
> > > > > > ExecutionLog table shows the report took < 1 second to pull the
> data,
> > > > > > but 22 seconds to process the report.
> > > > > >
> > > > > > Given that my high end server can perform millions of calcs per
> > > > > > second, does anyone know why my report would take so long to
> process?
> > > > > > The error logs show nothing unusual.
> > > > > >
> > > > > > Thanks,
> > > > > >
> > > > > > Burt

3GB switch in boot ini

I have a server which has 4gig of memory. I have
modified the boot.ini file to include the /3GB switch. I
have looked at the process work set for SQLServer and it
still appears to be using only 2gig's of memory. This
server does have WIN2K Advance server and is also SQL
Server 200 Enterprise.
How can I find out if SQL Server is using the 3 gig I
have available?
thanksPerformance Monitor Counter:
SQL Server: Memory Manager:Total Server Memory
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> I have a server which has 4gig of memory. I have
> modified the boot.ini file to include the /3GB switch. I
> have looked at the process work set for SQLServer and it
> still appears to be using only 2gig's of memory. This
> server does have WIN2K Advance server and is also SQL
> Server 200 Enterprise.
> How can I find out if SQL Server is using the 3 gig I
> have available?
> thanks|||"Kevin" <anonymous@.discussions.microsoft.com> wrote in message
news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> I have a server which has 4gig of memory. I have
> modified the boot.ini file to include the /3GB switch. I
> have looked at the process work set for SQLServer and it
> still appears to be using only 2gig's of memory. This
> server does have WIN2K Advance server and is also SQL
> Server 200 Enterprise.
> How can I find out if SQL Server is using the 3 gig I
> have available?
Performance monitor (Perfmon.exe) would be one way...
Steve|||That is what I used and it still only shows 1700544. The
Process:Work Set counter for SQLServr shows 1.7gig also.
I have SQL set to dynamic allocation. Seems the the
switch made no difference.
thanks
>--Original Message--
>Performance Monitor Counter:
>SQL Server: Memory Manager:Total Server Memory
>
>--
>Kevin Connell, MCDBA
>----
>The views expressed here are my own
>and not of my employer.
>----
>"Kevin" <anonymous@.discussions.microsoft.com> wrote in
message
>news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
>> I have a server which has 4gig of memory. I have
>> modified the boot.ini file to include the /3GB
switch. I
>> have looked at the process work set for SQLServer and
it
>> still appears to be using only 2gig's of memory. This
>> server does have WIN2K Advance server and is also SQL
>> Server 200 Enterprise.
>> How can I find out if SQL Server is using the 3 gig I
>> have available?
>> thanks
>
>.
>|||Something in the back of mind is reminding me that you actually need more
than 4GB of RAM to take advantage of >2GB memory, and that that docs are
either wrong or misleading, but I may be thinking about PAE/AWE. Try to
enable /PAE and AWE and see where that leads you.
--
Kevin Connell, MCDBA
----
The views expressed here are my own
and not of my employer.
----
<anonymous@.discussions.microsoft.com> wrote in message
news:00c601c39fe7$b63eb310$a601280a@.phx.gbl...
> That is what I used and it still only shows 1700544. The
> Process:Work Set counter for SQLServr shows 1.7gig also.
> I have SQL set to dynamic allocation. Seems the the
> switch made no difference.
> thanks
> >--Original Message--
> >Performance Monitor Counter:
> >
> >SQL Server: Memory Manager:Total Server Memory
> >
> >
> >--
> >Kevin Connell, MCDBA
> >----
> >The views expressed here are my own
> >and not of my employer.
> >----
> >"Kevin" <anonymous@.discussions.microsoft.com> wrote in
> message
> >news:00b501c39fc8$debf2410$a101280a@.phx.gbl...
> >> I have a server which has 4gig of memory. I have
> >> modified the boot.ini file to include the /3GB
> switch. I
> >> have looked at the process work set for SQLServer and
> it
> >> still appears to be using only 2gig's of memory. This
> >> server does have WIN2K Advance server and is also SQL
> >> Server 200 Enterprise.
> >>
> >> How can I find out if SQL Server is using the 3 gig I
> >> have available?
> >>
> >> thanks
> >
> >
> >.
> >