|
Hello,
We are planning to use file system device (with dsync false
& directio false) for tempdb with ASE 15.0.3 on RHEL5.3.
Looks like, redhat only supports async IO on ext3 with
O_DIRECT and not on buffered mode. Just wanted to know if
anybody has...
Started by Raj on
, 4 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
master:1master:2 device_name physical /opt/sybase/tempdb/tempdbdev....
On 10 Sep 2009 13:14:04 -0700, Niksa Jurinovic <niksa@jurinovic.de
Hi,
I am using tempdb on FS (ext3) device tempdbdev with dsync off and directio
off.
|
|
On Thu, 15 Jan 2009 12:01:00 -0800, Joe K. <Joe K.@discussions.microsoft.com
What is the minimum permission required to create a table within TempDB in a
SQL Server 2000 database server?
Thanks,
Started by Joe K. on
, 4 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
Another thing about creating users in tempdb is that tempdb itself is
recreated to have a startup stored....
The
ability to create tables within tempdb database?
Thanks,
> On Fri, 16 Jan 2009 09:48:51 or
to the specific user.
|
|
On Tue, 19 May 2009 12:49:51 -0400, "Eric S" <NoSpam@Hotmail.com
Hi All,
Using ms sql 2008 enterprise.
I need to find ways to move the TempDB from this folder C:\Program
Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA into drive E which...
Started by Eric S on
, 5 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
USE master
GO
ALTER DATABASE TempDB MODIFY FILE
(NAME = tempdev, FILENAME the below code to move the TempDB and Templog, I guess that
should do it, unless there are other hidden =
'E:\HumanFinders_Data\....
Points to be discoverd.
|
Ask your Facebook Friends
|
On 18 Nov 2009 02:17:57 -0800, "Luc Van der Veurst" <dba_azvub@hotmail.com
<Toni
How big is your master device now? How big is your master, model and
sybsystemdb (I assume you mean this databases with sybsystmpdb) ?
How much tempdb space is ...
Started by Luc Van der Veurst on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at omgili):
The owner (user_id) of this view is empty
could....
Specify owner.objectname or use sp_help to check
whether the object exists (sp_help may produce lots of
output) .
I have a view that exists in sysobjects but I am unable to
select from it
not found .
|
|
I have a SQL Server 2005 sp2 box where tempdb has either 8 data files or 5 data files dependingo n where you look. DBCC showfilestates and sys.database_files (both queried in tempdb) show 8 data files (tempdev - tempdev8), however when I query sys.master...
Started by Vendoran on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
The first question I have to ask is, why are you messing with tempdb? Are you experiencing bottlenecks because of tempdb?
If you look on disk in the appropriate directory, how many files do you see dropped from tempdb but SQL Server....
|
|
On Mon, 7 Jul 2008 14:43:49 -0300, "Carlos Felipe Frana da Fonseca" <carlosfelipefranca@gmail.com
Is it a good practice separate master.mdf and master_log.ldf in different
drives?
If yes, how?
Thanks,
Felipe
Started by Carlos Felipe Frana da Fonseca on
, 6 posts
by 4 people.
Answer Snippets (Read the full thread at omgili):
It's simpler performance, such as Tempdb....
There aren't many changes on the
master database, and you can't use its log for point in time recovery anyway.
For separating the master mdf file
and master ldf file to different drives.
|
|
What are the things I have to consider when I have to install SQL Server (2005/2008) on a new server?
Storage setup TempDB Security What are some common mistakes made in that process?
Started by splattne on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at serverfault):
Simplifying the list in SQL Server Management Studio):
USE master REVOKE VIEW ANY DATABASE FROM PUBLIC GO.
|
|
I have a stored procedure that gets all the non-system database names from a SQL Server:
select name from MySQLServer.master.sys.databases where name not like ('master') and name not like ('tempdb') and name not like ('msdb') and name not like ('model...
Started by Paige Watson on
, 5 posts
by 5 people.
Answer Snippets (Read the full thread at stackoverflow):
AS VARCHAR(15))+'.master.sys.databases' + CHAR(10) + 'where name not in (''master'',''tempdb.
|
|
On Wed, 11 Mar 2009 13:48:22 -0700, tony <tony@discussions.microsoft.com
I started my SQL instance in Single User Mode using -c -m parameter
This is what i have
*********************************
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL...
Started by tony on
, 5 posts
by 2 people.
Answer Snippets (Read the full thread at omgili):
My guess would be because the GUI interface will try to access meta data for
each ... .
To restore?
And after you restore the master database SQL Server will shut down because
it needs ued
command prompt to do the restore for master db.
|
|
We have purchased a new server to act as a MS SQL backend. I am curious to know what the best setup would be for it.
The server is a Dell R710 it has 6 hard drives 2x 74GB 15k and 4x 146GB 15k
This is currently setup in a RAID 1/Raid10 configuraton.
My...
Started by ITGuy24 on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at serverfault):
Physical....
Are you me from parallel universe?
James
TempDB I did some research a while ago about tempdb tempdb performance pay attention to physical disk configuration, file configuration, as well as some settings within the database.
|
