Defrag on SQL Server.....

I am periodically getting the complaints that SQL Server is slow. As a
performance improvements I decided to run the defrag utility. Never run on
this server from years. How to know that defrag need to be run? How to prove
there is an excessive physical file fragmentation on a Windows 2K?
SQL 2K with SP3 and Windows 2K with latest SP.
Thank you,
Larry
Larry,
Check out:
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pro.../ss2kidbp.mspx
HTH
Jerry
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to
> prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>
|||If you refer to the file system, you wouldn't need defrag if you stay away from constantly growing
and shrinking the database files. Keep them at a stable size and increase the size only when needed.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>
|||I saw your postings about defragging indexes and wondered if anyone
would be willing to help me out. I work for a software house that has
developed database defragmentation software for SQL Server, and we are
looking for beta-testers with DBA knowledge of SQL Server and an
awareness of fragmentation. Our software can defrag selected indexes on
a chosen table, one after the other, and has scheduling facilities
built in.
If anyone is interested in beta-testing it, I would like to hear from
you as it is close to launch. My company is willing to offer a free
copy of the software to anyone who can provide genuine and useful
feedback. Please post back if you are interested!
Regards,
Martin
Larry Smith wrote:
> I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry

Defrag on SQL Server.....

I am periodically getting the complaints that SQL Server is slow. As a
performance improvements I decided to run the defrag utility. Never run on
this server from years. How to know that defrag need to be run? How to prove
there is an excessive physical file fragmentation on a Windows 2K?
SQL 2K with SP3 and Windows 2K with latest SP.
Thank you,
LarryLarry,
Check out:
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/pr...n/ss2kidbp.mspx
HTH
Jerry
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to
> prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||If you refer to the file system, you wouldn't need defrag if you stay away f
rom constantly growing
and shrinking the database files. Keep them at a stable size and increase th
e size only when needed.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to pro
ve
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||I saw your postings about defragging indexes and wondered if anyone
would be willing to help me out. I work for a software house that has
developed database defragmentation software for SQL Server, and we are
looking for beta-testers with DBA knowledge of SQL Server and an
awareness of fragmentation. Our software can defrag selected indexes on
a chosen table, one after the other, and has scheduling facilities
built in.
If anyone is interested in beta-testing it, I would like to hear from
you as it is close to launch. My company is willing to offer a free
copy of the software to anyone who can provide genuine and useful
feedback. Please post back if you are interested!
Regards,
Martin
Larry Smith wrote:
> I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to pro
ve
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry

Defrag on SQL Server.....

I am periodically getting the complaints that SQL Server is slow. As a
performance improvements I decided to run the defrag utility. Never run on
this server from years. How to know that defrag need to be run? How to prove
there is an excessive physical file fragmentation on a Windows 2K?
SQL 2K with SP3 and Windows 2K with latest SP.
Thank you,
LarryLarry,
Check out:
Microsoft SQL Server 2000 Index Defragmentation Best Practices
http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/ss2kidbp.mspx
HTH
Jerry
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to
> prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||If you refer to the file system, you wouldn't need defrag if you stay away from constantly growing
and shrinking the database files. Keep them at a stable size and increase the size only when needed.
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Larry Smith" <LSmith_Melbourne@.hotmail.com> wrote in message
news:OBRu9MgxFHA.2504@.TK2MSFTNGP10.phx.gbl...
>I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry
>|||I saw your postings about defragging indexes and wondered if anyone
would be willing to help me out. I work for a software house that has
developed database defragmentation software for SQL Server, and we are
looking for beta-testers with DBA knowledge of SQL Server and an
awareness of fragmentation. Our software can defrag selected indexes on
a chosen table, one after the other, and has scheduling facilities
built in.
If anyone is interested in beta-testing it, I would like to hear from
you as it is close to launch. My company is willing to offer a free
copy of the software to anyone who can provide genuine and useful
feedback. Please post back if you are interested!
Regards,
Martin
Larry Smith wrote:
> I am periodically getting the complaints that SQL Server is slow. As a
> performance improvements I decided to run the defrag utility. Never run on
> this server from years. How to know that defrag need to be run? How to prove
> there is an excessive physical file fragmentation on a Windows 2K?
> SQL 2K with SP3 and Windows 2K with latest SP.
> Thank you,
> Larry

default schema for NT-group not possible

We have a new development SQL2005 server.
To implement secutiry on this new server we decided to grant rights to NT-groups.
We defined an NT-group Programmersmembers and gave this group the necessary rights.
The problem now is when a member of this NT-group creates a table (this group is dbo in the development database) everything works fine as expected.
But when a member of this group tries to make a new table through 'Microsoft SQL server management studio' they receive the error that there is no default schema available.
But it seems to be impossible to map a default schema to an NT-Group.

=> Does this means we have no other way than to give each individual programmer the necessary rights and assign them to a default schema.
It is no option to force our programmers to create each table through a script on the development database.

Or is there another option ?

For the general issue of setting a schema for a group, see this thread: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=79418&SiteID=1.

If you have a limited number of operations that you want your users to perform, you could expose them through stored procedures that use the EXECUTE AS to run under a context with a well defined default schema. See http://msdn2.microsoft.com/en-us/library/ms188354.aspx for more information on EXECUTE AS.

Thanks
Laurentiu

|||

Setting a default schema for a group is not supported in SQL Server. The root cause of the problem in this case seems to be a bug in Microsoft SQL Server management studio that is already in our radar.

For more details, you can see the original discussion for this bug at http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=79418&SiteID=1 .

I hope this information can help you.

-Raul Garcia

SDE/T

SQL Server Engine

|||

Just to clarify the SQL Server Management Studio bug. If you create the table directly using TSQL, the operation should succeed and create an implicit user. Management Studio's bug is that it requires the user to be already created.

-Raul Garcia

SDE/T

SQL Server Engine

-

This posting is provided "AS IS" with no warranties, and confers no rights.

|||

Raul & Laurentiu

thx for the explination and the link to the other thread