PF numbers

Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
this number is calculated. According to help : It is 'The amount of paging
file being used by the system.' Considering I have paging file 2GB big how
come Task Manager shows 10.3 GB?
Thanks you in advance,
Igor
Hi
Have you checked that the Page File is not also on other discs?
What does performance monitor show for this?
John
"imarchenko" wrote:

> Hello!
> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
> RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
> this number is calculated. According to help : It is 'The amount of paging
> file being used by the system.' Considering I have paging file 2GB big how
> come Task Manager shows 10.3 GB?
>
> Thanks you in advance,
> Igor
>
>
|||John,
There is only one Page File located on drive C.
Igor
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ABD53369-1AEC-4893-A353-58DE3D716359@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked that the Page File is not also on other discs?
> What does performance monitor show for this?
> John
> "imarchenko" wrote:

PF numbers

Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
this number is calculated. According to help : It is 'The amount of paging
file being used by the system.' Considering I have paging file 2GB big how
come Task Manager shows 10.3 GB?
Thanks you in advance,
IgorHi
Have you checked that the Page File is not also on other discs?
What does performance monitor show for this?
John
"imarchenko" wrote:
> Hello!
> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
> RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
> this number is calculated. According to help : It is 'The amount of paging
> file being used by the system.' Considering I have paging file 2GB big how
> come Task Manager shows 10.3 GB?
>
> Thanks you in advance,
> Igor
>
>|||John,
There is only one Page File located on drive C.
Igor
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ABD53369-1AEC-4893-A353-58DE3D716359@.microsoft.com...
> Hi
> Have you checked that the Page File is not also on other discs?
> What does performance monitor show for this?
> John
> "imarchenko" wrote:
>> Hello!
>> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
>> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB
>> of
>> RAM. SQL Server is restricted to 10GB. There is only one page file
>> 2046MB.
>> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
>> this number is calculated. According to help : It is 'The amount of
>> paging
>> file being used by the system.' Considering I have paging file 2GB big
>> how
>> come Task Manager shows 10.3 GB?
>>
>> Thanks you in advance,
>> Igor
>>
>>

PF numbers

Hello!
I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
this number is calculated. According to help : It is 'The amount of paging
file being used by the system.' Considering I have paging file 2GB big how
come Task Manager shows 10.3 GB?
Thanks you in advance,
IgorHi
Have you checked that the Page File is not also on other discs?
What does performance monitor show for this?
John
"imarchenko" wrote:

> Hello!
> I am puzzled by PF Usage numbers reported on our SQL server. It is SQL
> Server 2000 (SP3a) running on Windows 2003 Enterprise Server with 12 GB of
> RAM. SQL Server is restricted to 10GB. There is only one page file 2046MB.
> When I open Task Manager PF Usage numbers are 10.3 GB. I am not sure how
> this number is calculated. According to help : It is 'The amount of paging
> file being used by the system.' Considering I have paging file 2GB big how
> come Task Manager shows 10.3 GB?
>
> Thanks you in advance,
> Igor
>
>|||John,
There is only one Page File located on drive C.
Igor
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:ABD53369-1AEC-4893-A353-58DE3D716359@.microsoft.com...[vbcol=seagreen]
> Hi
> Have you checked that the Page File is not also on other discs?
> What does performance monitor show for this?
> John
> "imarchenko" wrote:
>

Permissions not saved

HI,
SQL2k ( SP3a) ( I also install SP3a for the tools on my
workstation)
I encounter a strange problem when I try to set permissions on VIEW
Grant select on dbo.view_name to PUBLIC
Deny insert, update, delete on dbo.view_name to PUBLIC
With QA, when I execute thoses 2 commands ( Grant and Deny), those
commands are =93completed successfully=94 BUT =85. when I go to EM / Vi=
ew /
properties / permissions, nothing have been saved for PUBLIC role. If
I change persmission by clicking , go out of EM and when I go back in,
the permissions are back the way they were before I changed them
(nothing is saved)
Also, when I execute "sp_helprotect view_name" the result is:
Server: Msg 15330, Level 11, State 1, Procedure sp_helprotect, Line 346
There are no matching rows on which to report.
I tried with a =93user =93 instead of the PUBLIC role, and I have the sam=
e
problem.
I tries using SA account, and I have the same problem
I tried working on others worksations or on the console without success
I tried re-install =93sp3a=94 for the tools on my workstation without
success.
I will try to use PROFILER tomorrow.
Is it a bug with SP3a ? Is it a collation problem ?
Any idea '
Thank you
DannyHi Danny,
I believe I know the answer to part of your information. When EXEC
sp_helprotect <view name> returns a result set "There are no matching rows
on which to report", it means that a view by the name specificed does not
exist in the current database. Double check the database name listed in
the drop down at the top of Query Analyzer. Verify the database name shown
is the database name that contains the view name.
The second part of your information is more difficult to test. If you
register a server via SQL Enterprise Manager and you register using an
account that is part of the System Admin server role, you should be able to
make any permissions changes you wish and have them stick. My suspicion is
you registered SQL Server in SQL Enterprise Manager with an account that is
not a member of the System Admin role.
Please let me know what role the account holds within SQL Server.
Thanks.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.|||Thank you Gary,
I Verified that the BD's name shown is the database name that contains th=
e view
name.
I Verified that I registered SQL Server in SQL Enterprise Manager with an=
account that is
a member of the System Admin role. I also tried to register SQL Server in=
SQL
Enterprise Manager ans QA with "SA" .
Additional information: I have 2 similars DB on the same server machine.
For the first one, persmissions are saved and I can verify with SP_Helpro=
tect
For the other one, permissions are not saved and SP_Helprotect returns a=
result set "There are no matching rows on which to report",
Tonight dbreindex and Updatestat will be executed
Thank you
Danny
"Gary Whitley [MSFT]" a =E9crit :

quote:

---

> Hi Danny,
> I believe I know the answer to part of your information. When EXEC
> sp_helprotect <view name> returns a result set "There are no matching r=

---

ows

quote:

---

> on which to report", it means that a view by the name specificed does n=

---

ot

quote:

---

> exist in the current database. Double check the database name listed i=

---

n

quote:

---

> the drop down at the top of Query Analyzer. Verify the database name s=

---

hown

quote:

---

> is the database name that contains the view name.
> The second part of your information is more difficult to test. If you
> register a server via SQL Enterprise Manager and you register using an
> account that is part of the System Admin server role, you should be abl=

---

e to

quote:

---

> make any permissions changes you wish and have them stick. My suspicio=

---

n is

quote:

---

> you registered SQL Server in SQL Enterprise Manager with an account tha=

---

t is

quote:

---

> not a member of the System Admin role.
> Please let me know what role the account holds within SQL Server.
> Thanks.
> Gary Whitley
> This posting is provided "AS IS" with no warranties, and confers no rig=

---

hts.|||Danny,
Thank you for using the Microsoft newsgroups as your source for technical
information. In this particular case the complexity of your issue will
require in-depth troubleshooting and will not be best served by newsgroup
support. Please go to;
http://support.microsoft.com/common...=fh;en-us;cntac
tms
Select your region from the map and follow the instructions for contacting
our telephone support centers in your area.
Thank you.
Gary Whitley
This posting is provided "AS IS" with no warranties, and confers no rights.

Permissions

They removed the share off of the drive where my snapshot replication step
(SS 2000 SP3a) writes to. That's all well and good because someone had
accidently shared out the whole drive. But now my snapshot step is failing
with "process could not create \\server\h\repl\unc".
Of course, we added a share to the repl folder and it failed with the same
error msg. Then we added in the share to the whole drive again and it still
failed.
So I am wondering if some permissions got clobbered or changed. So here are
my q's:
1. What permissions does snapshot replication run under? Does it just run
under the main sql server service account?
2. Can we just share out the subfolder, i.e. either the repl or the unc
subfolder?
3. Is there anything else we should be troubleshooting?
Any help would be much appreciated...Nevermind - I got it to work.
"CLM" wrote:

> They removed the share off of the drive where my snapshot replication step
> (SS 2000 SP3a) writes to. That's all well and good because someone had
> accidently shared out the whole drive. But now my snapshot step is failin
g
> with "process could not create \\server\h\repl\unc".
> Of course, we added a share to the repl folder and it failed with the same
> error msg. Then we added in the share to the whole drive again and it sti
ll
> failed.
> So I am wondering if some permissions got clobbered or changed. So here a
re
> my q's:
> 1. What permissions does snapshot replication run under? Does it just ru
n
> under the main sql server service account?
> 2. Can we just share out the subfolder, i.e. either the repl or the unc
> subfolder?
> 3. Is there anything else we should be troubleshooting?
> Any help would be much appreciated...

Permissions

They removed the share off of the drive where my snapshot replication step
(SS 2000 SP3a) writes to. That's all well and good because someone had
accidently shared out the whole drive. But now my snapshot step is failing
with "process could not create \\server\h\repl\unc".
Of course, we added a share to the repl folder and it failed with the same
error msg. Then we added in the share to the whole drive again and it still
failed.
So I am wondering if some permissions got clobbered or changed. So here are
my q's:
1. What permissions does snapshot replication run under? Does it just run
under the main sql server service account?
2. Can we just share out the subfolder, i.e. either the repl or the unc
subfolder?
3. Is there anything else we should be troubleshooting?
Any help would be much appreciated...Nevermind - I got it to work.
"CLM" wrote:
> They removed the share off of the drive where my snapshot replication step
> (SS 2000 SP3a) writes to. That's all well and good because someone had
> accidently shared out the whole drive. But now my snapshot step is failing
> with "process could not create \\server\h\repl\unc".
> Of course, we added a share to the repl folder and it failed with the same
> error msg. Then we added in the share to the whole drive again and it still
> failed.
> So I am wondering if some permissions got clobbered or changed. So here are
> my q's:
> 1. What permissions does snapshot replication run under? Does it just run
> under the main sql server service account?
> 2. Can we just share out the subfolder, i.e. either the repl or the unc
> subfolder?
> 3. Is there anything else we should be troubleshooting?
> Any help would be much appreciated...