This may be a Really dumb Question, but I gotta ask it.
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJ
Hi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>
|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
2012年3月25日星期日
DISK IO Question
This may be a Really dumb Question, but I gotta ask it.
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJHi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>sql
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJHi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>sql
DISK IO Question
This may be a Really dumb Question, but I gotta ask it.
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJHi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
WHAT does the term IOPS "Really" Mean ?
I know, I Know...Input Output per second, but WHAT is an IO ?
The main issue is an IO 1byte, 1KB, 1 sector, or what ?
I need to estimate how long it's going to take to move 1GB of data from
Point A to B.
I intend to use DISK Specs of my 15k Drives to do this.
I estimate my drives to be capable of 128 IOPS.
so the golden question...128 WHAT ?
GAJHi
There are so many factors that affect IO performance. OS cache, disk
controller cach, RAID levels etc.
IO/sec does not help. Look at Disk "external transfer rate" to get a good
idea.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"pdxJaxon" wrote:
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
>|||See Microsoft SQL Server 2000 Performance Tuning Technical Articles from
Microsoft Press.
Adrian
"pdxJaxon" <GregoryAJackson@.Hotmail.com> wrote in message
news:uTWT4mUbFHA.2796@.tk2msftngp13.phx.gbl...
> This may be a Really dumb Question, but I gotta ask it.
> WHAT does the term IOPS "Really" Mean ?
> I know, I Know...Input Output per second, but WHAT is an IO ?
> The main issue is an IO 1byte, 1KB, 1 sector, or what ?
> I need to estimate how long it's going to take to move 1GB of data from
> Point A to B.
> I intend to use DISK Specs of my 15k Drives to do this.
> I estimate my drives to be capable of 128 IOPS.
> so the golden question...128 WHAT ?
>
> GAJ
>
2012年3月20日星期二
Discrepancy in number of rows and size of database
I'm trying to help a customer extract some data out of their SQL Server
database and am confused as to what I see.
First of all, this is my second day working with MS SQL Server so I'm not at
all up to speed on it as I am with other RDBMs.
This database is almost a gigabyte is size. There are roughly 25 user
tables in it. None of these tables have more than 250 records and none of
these records are very large.
According to the customer they thousands of records when they run the
application tha tuses this database. But I don't see them.
Could they be under a different owner? I see all of the "DBO" owned tables.
Unfortunately this customer doesn't have any documentation on the system and
the consultant who sold the system to them is long gone.
Any ideas?
TIA
Scott Huerta
Distinctive Solutions
Scott,
Database has reserved space, it does not have to be full. So I guess this is
the discrepancy you see.
If you are a member of the sysadmin role, you see all objects, no matter of
owner.
Where are the missing rows? I don't know. Check the Profiler tool in Books
OnLine, with this tool you can catch all commands SQL Server is receiving.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> I'm trying to help a customer extract some data out of their SQL Server
> database and am confused as to what I see.
> First of all, this is my second day working with MS SQL Server so I'm not
at
> all up to speed on it as I am with other RDBMs.
> This database is almost a gigabyte is size. There are roughly 25 user
> tables in it. None of these tables have more than 250 records and none of
> these records are very large.
> According to the customer they thousands of records when they run the
> application tha tuses this database. But I don't see them.
> Could they be under a different owner? I see all of the "DBO" owned
tables.
> Unfortunately this customer doesn't have any documentation on the system
and
> the consultant who sold the system to them is long gone.
> Any ideas?
> TIA
> Scott Huerta
> Distinctive Solutions
|||Thanks for the reply Dejan.
How do I make sure that I'm a member of the SysAdmin role? I think I might
already be as I can see system (i.e. "SYS...") tables and objects.
"Dejan Sarka" wrote:
> Scott,
> Database has reserved space, it does not have to be full. So I guess this is
> the discrepancy you see.
> If you are a member of the sysadmin role, you see all objects, no matter of
> owner.
> Where are the missing rows? I don't know. Check the Profiler tool in Books
> OnLine, with this tool you can catch all commands SQL Server is receiving.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
> news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> at
> tables.
> and
>
>
|||try sp_helpsrvrolemember @.srvrolename = 'sysadmin'
Bob Castleman
SuccessWare Software
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:76B2BB80-962A-4AE3-805A-3240D8EC5BCE@.microsoft.com...
> Thanks for the reply Dejan.
> How do I make sure that I'm a member of the SysAdmin role? I think I
> might
> already be as I can see system (i.e. "SYS...") tables and objects.
>
database and am confused as to what I see.
First of all, this is my second day working with MS SQL Server so I'm not at
all up to speed on it as I am with other RDBMs.
This database is almost a gigabyte is size. There are roughly 25 user
tables in it. None of these tables have more than 250 records and none of
these records are very large.
According to the customer they thousands of records when they run the
application tha tuses this database. But I don't see them.
Could they be under a different owner? I see all of the "DBO" owned tables.
Unfortunately this customer doesn't have any documentation on the system and
the consultant who sold the system to them is long gone.
Any ideas?
TIA
Scott Huerta
Distinctive Solutions
Scott,
Database has reserved space, it does not have to be full. So I guess this is
the discrepancy you see.
If you are a member of the sysadmin role, you see all objects, no matter of
owner.
Where are the missing rows? I don't know. Check the Profiler tool in Books
OnLine, with this tool you can catch all commands SQL Server is receiving.
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> I'm trying to help a customer extract some data out of their SQL Server
> database and am confused as to what I see.
> First of all, this is my second day working with MS SQL Server so I'm not
at
> all up to speed on it as I am with other RDBMs.
> This database is almost a gigabyte is size. There are roughly 25 user
> tables in it. None of these tables have more than 250 records and none of
> these records are very large.
> According to the customer they thousands of records when they run the
> application tha tuses this database. But I don't see them.
> Could they be under a different owner? I see all of the "DBO" owned
tables.
> Unfortunately this customer doesn't have any documentation on the system
and
> the consultant who sold the system to them is long gone.
> Any ideas?
> TIA
> Scott Huerta
> Distinctive Solutions
|||Thanks for the reply Dejan.
How do I make sure that I'm a member of the SysAdmin role? I think I might
already be as I can see system (i.e. "SYS...") tables and objects.
"Dejan Sarka" wrote:
> Scott,
> Database has reserved space, it does not have to be full. So I guess this is
> the discrepancy you see.
> If you are a member of the sysadmin role, you see all objects, no matter of
> owner.
> Where are the missing rows? I don't know. Check the Profiler tool in Books
> OnLine, with this tool you can catch all commands SQL Server is receiving.
> --
> Dejan Sarka, SQL Server MVP
> Associate Mentor
> www.SolidQualityLearning.com
> "Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
> news:EDE920CD-F82C-48BC-AA10-FC5885BCC4D3@.microsoft.com...
> at
> tables.
> and
>
>
|||try sp_helpsrvrolemember @.srvrolename = 'sysadmin'
Bob Castleman
SuccessWare Software
"Scott Huerta" <Scott Huerta@.discussions.microsoft.com> wrote in message
news:76B2BB80-962A-4AE3-805A-3240D8EC5BCE@.microsoft.com...
> Thanks for the reply Dejan.
> How do I make sure that I'm a member of the SysAdmin role? I think I
> might
> already be as I can see system (i.e. "SYS...") tables and objects.
>
2012年3月7日星期三
Disallow connection for a second or two
Hi
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
Newish
You can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegro ups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>
|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:[vbcol=seagreen]
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegro ups.com...
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
Newish
You can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegro ups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>
|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:[vbcol=seagreen]
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegro ups.com...
Disallow connection for a second or two
Hi
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
NewishYou can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> > Hi
> >
> > Is it possible to prevent users of a database in SQL Server 2005 from
> > doing anything for a second or two.
> >
> > Can this be done using a stored procedure.
> >
> > thanks
> >
> > Newish
> >
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
NewishYou can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
--
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> > Hi
> >
> > Is it possible to prevent users of a database in SQL Server 2005 from
> > doing anything for a second or two.
> >
> > Can this be done using a stored procedure.
> >
> > thanks
> >
> > Newish
> >
Disallow connection for a second or two
Hi
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
NewishYou can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:[vbcol=seagreen]
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
Is it possible to prevent users of a database in SQL Server 2005 from
doing anything for a second or two.
Can this be done using a stored procedure.
thanks
NewishYou can put the database into readonly mode. In the proc do a
ALTER DATABASE AdventureWorks SET READ_ONLY
Hilary Cotter
Director of Text Mining and Database Strategy
RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
This posting is my own and doesn't necessarily represent RelevantNoise's
positions, strategies or opinions.
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
"Newish" <ahussain3@.gmail.com> wrote in message
news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
> Hi
> Is it possible to prevent users of a database in SQL Server 2005 from
> doing anything for a second or two.
> Can this be done using a stored procedure.
> thanks
> Newish
>|||Thanks Hilary.
Would this scenario work. Use a stored procedure to issue this
command. Then the same procedure writes a couple of pieces of info to
a table and then revoke this statement.
Hence, during the readonly state will the stored procedure be able to
write.
How do you revert back to read and write status.
thanks once again.
Newish
Hilary Cotter wrote:[vbcol=seagreen]
> You can put the database into readonly mode. In the proc do a
> ALTER DATABASE AdventureWorks SET READ_ONLY
> --
> Hilary Cotter
> Director of Text Mining and Database Strategy
> RelevantNOISE.Com - Dedicated to mining blogs for business intelligence.
> This posting is my own and doesn't necessarily represent RelevantNoise's
> positions, strategies or opinions.
> 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
>
> "Newish" <ahussain3@.gmail.com> wrote in message
> news:1160218524.169852.196200@.i3g2000cwc.googlegroups.com...
2012年2月17日星期五
disable log on user login events
my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?Originally posted by timothymo
my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?
Hi.... :)
Open / Close of DB file is not an issue its an configuration setting in Select DB Right click /Property / Options tab - Auto Close on-Off. This is to release the resource while DB is not in use. When any user use this DB the DB file will be opened.
If you don't want to use the login to be logged disable Server property / Security - Audit level (None or failure)
Cheers ,
Shaji
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?Originally posted by timothymo
my server is have user login (by services) 5~8 times per second, and all these events are logged in sql log and system application events log.
will this cause problem to the server? as each entry will cause a open/close action.
if yes, how can i disable them?
Hi.... :)
Open / Close of DB file is not an issue its an configuration setting in Select DB Right click /Property / Options tab - Auto Close on-Off. This is to release the resource while DB is not in use. When any user use this DB the DB file will be opened.
If you don't want to use the login to be logged disable Server property / Security - Audit level (None or failure)
Cheers ,
Shaji
订阅：
博文 (Atom)