Scalability With Mount Points

Feb 28, 2008

I understand mount points help scalability in easier maintenance.
By scalability do we mean more than 26 drive letters or it means adding more space to the same mount point letter on with more ease .

Can I add more space to a mountpoint if required later on by adding hard disks .

Also if one can give some pointers to good file group configuration guidelines / storage align partitions , it will be very much helpful

Further I my server CPU has 4 cores , will having 4 filegroups help me in improving system performance.


If SAN has 2 controllers , is it preferred to run data file partition on one controller and log file partition on another.

Thanks in advance.

View 1 Replies


ADVERTISEMENT

Mount Points

Nov 23, 2006

I know how to create mount point in windows 20003 cluster, I am not sure how
to set it up with SQL 2005 running on the cluster.
Does sql need to be dependant on any of the disks? I have tried looking for
a guide, but cannot find.

current setup active active cluster running. I need to add san space which
will hold the databases. The san will be carved up into drive letters. each
drive letter will hold 3 mount points.
ie.
node 1
J:-2 mount point
k:2 mount point
l:2 mount point

node 2-
r:-2 mount point
s:2 mount point
t:2 mount point

each node would be able to own the disk if the other node failed over.

any help is appreciate. I have tried books online etc.. cannot find a good
step by step.;


thanks

View 1 Replies View Related

Monitoring Mount Points

Sep 25, 2007

Hello,
We have a requirement to be able to monitor mount points. The xp_fixeddrives does not support mount point monitoring. Is there another way to do it. Does microsoft working on updating the xp_fixeddrives. Let me know if anyone has any ideas how to monitor mount points.

Thanks

View 1 Replies View Related

Is It Safe To Use Volume Mount Points With SQL 2005?

Jul 20, 2006

Hello,

To implement the new SQL 2005, I plan to make the environment easy to manage. The environment should be simple to document and be automated via scripts. Therefore I plan to use mount points as described below.

On a typical SQL server with multiple drives like C, D, E, F, G, H. Where each drive will have various folders to hold SQL code, data files, transaction log files, tempdb files, snapshot files, and other types of files. This typical environment is not pretty and is hard to write scripts for.

So I plan to standardize on one standard directory structure via volume mount point. On all new SQL 2005 servers, we should see drive E as the one and only SQL Server directory. Other drives will be mounted to drive E as shown.

E:

SQLSERVER local folder -sql code for each db instance

SQLSHARED local folder -sql shared tools for all db instances

SQLTLOG1 Drive H -db transaction log

SQLSNAP1 Drive F -db snapshot files

SQLTEMPDB1 Drive H -tempdb main data file

SQLWORK Drive D - DBA work area

SQLDATA1 Drive G -db data files

SQLDATA2 Future Drive -if SQLDATA1 is too large for any direct attached drive, or to get more I/O throughput.

With this implementation, I can easily write scripts to manage the environment. Also if any mounted volume is out of space, we can swap the based drive without doing any change to database configuration. We can also switch from direct attached drive to SAN in the future.

Do you think mount point is safe to use with SQL 2005? I know it is supported.

Do you have a standard directory structure for your environment? How do you do it?

Thanks,

KTMD

View 2 Replies View Related

SQL 2012 :: Does Mount Points Support Filestream Feature

Apr 9, 2014

Does sql server 2012 mount points support FileStream feature?

View 1 Replies View Related

Transact SQL :: Check For Mount Points And Retrieve Available Space

Jun 8, 2015

I have to check for existence of mount points on drives and retrieve the Space information for those mount points. Is this even possible with t-sql??

View 2 Replies View Related

Update Cur_points With Cur_points+points, Then Wipe Points (was Help Needed Please)

Jun 22, 2007

Greetings everyone, I'm posting this thread with the hope that someone will notice it and might offer me a helping hand regarding one of my problems.I have the database named "DBEXAMPLE" with the table MEMB_INFO that contains two important columns that are named cur_points and points where cur_points column contains the total available points that a member can use/spend on a game and the points column stores the total of the points that a member used so far.So as i plan to wipe all data of the database, i need to keep the member login,password and total points that each member purchased.So i will somehow need to update the cur_points column with the total of current cur_points+points columns and then wipe points column.I've personally asked a friend regarding this and he said that this should be something complicated and it might require php also.Really appreciate if someone could help me regarding this.small schema:Database: DBEXAMPLETable: MEMB_INFOColumn cur_points -> total available points that a member can spendColumn points -> total points that the member has already spentColumn memb___id -> member login aka account idTODO -> update cur_points column with the total of cur_points+points columns for each member(buyer)With best regards.

View 5 Replies View Related

How To Test Scalability

Dec 5, 2007

Hi,

Whats the best way to test scalability on a database? I'm working on a new app, and have handed off developing the database to someone with more experience. Some tables will grow to many million records, and I don't want it to bottleneck. I need to have it fully tested before it goes live.

Is it reasonable to ask the person helping me to fill it with 10's of millions of rows to test performance? Is this a decent solution? If so, what would the best way to fill it be? If not, what steps should I take?

Thanks very much!
mike123

View 2 Replies View Related

SQL Server Scalability

Jul 23, 2005

Could someone out there please help me to answer these questions?Thanks in advance.1. What aspects of SQL Server allow it to reliably scale up to supporta large global enterprise? And, when does SQL Server reliabilitybegin to fail?2. Given a role-based security model and without doing a benchmark,are there potential performance issues of using a SQL Server database ?How would this change if more of the security was moved to theapplication level or moved to the database?3. How does SQL Server manage access to data at the record and datafield level?4. w do support and administration requirements compare between SQLServer (or MSDE) and Oracle? Consider levels of expertise needed fromcentral server to desktop implementations.

View 1 Replies View Related

Scalability Of Ssrs

Feb 14, 2007

hi all

i want to know that how much performance of ssrs will be vary when i m installing ssrs on same machine where my database is stored, or when i m storing ssrs on different machine and database on different machine.

View 3 Replies View Related

Performance And Scalability

Nov 7, 2006

Hi, I'm looking for some recent surveys on the performance of ETL-Tools including SSIS and relates it to other ETL-vendors. Any ideas where to find valid stuff?

S.

View 1 Replies View Related

Scalability OF SSIS

Nov 23, 2005

I am trying to find some information on recommended deployments, preferably with a diagram for a presentation.

View 12 Replies View Related

SQL7 User Scalability

Mar 10, 2000

Hello All,

I was just looking for some rough estimates on the number of simultaneous users that SQL7 EE can support in a Web (IIS/ASP) environment. I know there are a lot of configuration issues that will effect the answer, but assume that there are a couple of IIS servers running WLBS that need to connect to the SQL database for query and update functionality. Of course, all access to the database will be controlled through stored procedures. Any thoughts would be most appreciated...

Thanks,

Chris

View 1 Replies View Related

Performance With Respect To Scalability

Dec 5, 2007

Our databases were working fine in terms of performance until over the last 2 months wherein the timeouts and deadlocks have started increasing. We are having growing clients with huge real-time transactions. We have been adding NOLOCKs on queries that are being used frequently etc but the timeouts are still an issue. Not sure what the best way to identify problem areas is. The CPU utilization has also been on the higher side. Profiler identified long queries are being indexed etc. But the performance is still a concern. Any ideas? What am i not looking at? HELP HELP..

Thanks,
Sri

View 16 Replies View Related

High Availability And Scalability ...

Jul 12, 2006

We have a multi-lingual website (English, Spanish and German). We have a table called Posts that is potentially getting really big.

We are in the initial design phase of the database and would like to know what the experts are suggesting to keep our database mean and lean in the long run.

We have been talking about splitting the database up into 3 separate databases, one for English, one for Spanish and one for German. The language specific databases would also be hosted in countries where the language is spoken eg. the German database would be hosted in Germany.

Or maybe database partitioning by language???

Making changes to 3 databases once launched seems like a nightmare. It would be nice to have one main database and maybe 2 (Spanish and German) €œsatellite€? databases or something like that €“ any ideas???.

Any suggestions of how to deal with this problem the best way would be greatly appreciated. We are using SQL Server 2005.

Newbie!

View 4 Replies View Related

Balancing Scalability With Availability

Jun 16, 2006

We are beginning to design a new application with SQL Server 2005. Our current production environment is slated to be two SQL Server 2005 machines with the databases residing on an EMC SAN. We have requirements to both have automatic failover between servers for availability and also be able to balance the load over two hot servers for scalability.

Can anyone point me in the right direction for things I need to consider in order to be able to implement both of these requirements? Can I implement database mirroring (for failover) and transactional replication (for balancing) given the hardware configuration I'v mentioned? Is more information needed? Where should I turn next?

I am coming off a mainly Oracle background for the last ten or so years with a smattering of SQL Server mixed in. I've tried to hit the ground running on this project, but sometimes find myself hitting the wall running instead.

Thanks,

Larry

View 3 Replies View Related

Recovery Of Database On A Mount Point

Jul 26, 2007



When restoring a database where the data file(s) are located under a mount point, seems to be a problem with reporting free space available.

DB Size - Say 30GB (25 Data, 5 Log)

E: Drive 20GB with 15GB Free


Restoring database file to
E:SQLMountPoint

- This points to separate disk with more than enough free space

SQL prevents the restore by stating there is not enough free space.

A long work around is
assign a drive letter to the large disk
Restore database using temp drive letter - F:SQLDATAMyDB_Data.mdf
Update sysfiles - changing drive & path - E:SQLMountPointSQLDATAMyDB_Data.mdf
Stop & restart database...

Is there a better way???
Wishlist - Restore only warns about free space - but allows continue...

Regards

View 7 Replies View Related

Scalability Issues With Using IDENTITY Columns

Jul 21, 2000

We have a high load site that requires some redesign. We would like to move the PK generation from a custom scheme to IDENTITY columns.

What are the any scalability issues for using IDENTITY? Will contention issues arise because of row locking?

Thanks in advance.

View 7 Replies View Related

Do We Still Need A Common Share Mount Point In SQL2K5

Mar 13, 2006

Replication in SQL2K required a common file share between publisher and subsriber.

Our security policy will not allow our DB servers to communicate via net bios across the firewall.

Can SQL2K5 perform replication using the normal database communication ports (1433 or 2433)?

View 1 Replies View Related

Scalability Questions For Extended Stored Procedure

Jan 25, 2006

Hi,First I would like to apologize for cross posting in three groups asI did not know which one would be the appropriate group. If some onepoints me to the correct one I will use that in the future.I am trying to findout the scalabilty of an user written extendedstore procedure. I have created a dll using a C program(modified/plagarized from some of the examples) . The main function ofthis extended SP is to act as a passthru to connect to an third partyODBC driver. All this is supposed to do is take the passthru sqlstatement, userid, passsword and connect to a remote server (IBM 3090Mainframe in our case) using a system ODBC connection and pass thereturned result set back to the stored procedure calling this extendedSP. I am trying to find out the answers for the following questions.1. What are the limitations of this approach.2. What would happen say if 2,000 concurrent calls per minute are madeto the extended SP from the web app.3. What would happen if this continued for say 4 hours. Will the memoryusage increase to point that will cripple the server assuming there isno memory leak in the dll.4. Are there any connection pooling concerns that I should payattention to specifically from an Extended SP point of view.5. Apart from compiling the dll using the "MultiThread" option should Ibe using other options to make sure the dll is threadsafe.SQL server Environment :OS - Windows 2000 Advanced Server SP4SQL - SQLServer 2000 Enterprise edition SP3Hardware - 8 way 2 node cluster with 6Gb RAMAny help regarding this is greately appreciated.Prahalad

View 3 Replies View Related

Can't Create File At The Root Level Of Mount Point

Sep 14, 2006

Dear all,

I was trying to create filegroup and files on Mount Point, e.g. C:MOUNTFG1D1
If I try this:
.......
FILENAME = 'C:MOUNTFG1D1FG1F1.ndf',

It doesn't work, no matter what ACL I set on C:, C:MOUNT, or C:MOUNTFG1D1

But if I do this:

......
FILENAME = 'C:MOUNTFG1D1DATAFG1F1.ndf',

It will work, no need to set any ACL at all.

Any ideas?

dong

View 2 Replies View Related

DB Engine :: Failover Cluster Instance With Mount Point

Jun 25, 2014

I've a fresh installation of SQL Server 2014 Enterprise on Windows Server 2012R2. I've setup de Windows Server Failover Cluster and the validation test has been successfully passed. I use mountpoint so I've disk M: that is the host drive for mounted volume m:Isql2014A that is the base folder for mounted volume

On that folder I've 5 mountpoint:

1) m:isql2014a empdbdata
2) m:isql2014a empdblog
3) m:isql2014auserdata
4) m:isql2014auserlog
5) m:isql2014auserlog

into these 5 mountpoint I've placed the SQL Server files.

After the installation of the first FCI I've re-run the cluster validation wizard and again it has passed successfully. When I try to failover the instance from one node to the other I have 2 problem:

1) every time I do failover, some disks fail to come online for a while and then succeed :

Cluster resource 'CLD - IstA - TempDB Data' of type 'Physical Disk' in clustered role 'SQL Server (ISQL2014A)' failed. The error code was '0xaa' ('The requested resource is in use.').

2) sometimes the SQL Server service fails to start, in the error log I see that the master database is not accessible. The master database in into the m:isql2014abinbackup.

View 7 Replies View Related

SQL Server Admin 2014 :: Backing Up To Mount Point - Perfmon Shows Zero Writes

Apr 20, 2015

Im backing up to a network directory thats actually a mount point on a different server.My backup was slower than usual so i opened up perfmon to have a look.

When selecting the mount point from the Logical Disks section in perfmon i can see that writes/sec & write bytes/sec both show zero for a long period of time, even though the backup percent complete is increasing.Then all of a sudden the writes to the network share jump massively.

Is there some caching mechanism for backups in sql where during a backup data is only flushed to the disk periodically during backup?

View 1 Replies View Related

Generate 2 Decimal Points??? How?

Mar 12, 2007

HI All,
I use MSSQL as my database and ASP.NET as my front application. I want to display Price value S$23.68.
The dayatype I used is smallmoney, but it display: S$23.6800. HOw do I control the number of decimals point in the column of MSSQL??
 Thanks a lot
 Suigion

View 1 Replies View Related

How To Query A Table That Points To Itself

May 21, 2008

Dear experts,

Hi, I got a table name Employee, with the following fields

EmployeeID
Name,
ManagerID
ManagerID2,
ManagerID3,
ManagerID4 ..

ManagerID, ManagerID2, ManagerID3, ManagerID4 are all pointing to EmployeeID in the same table.

Now I want to select the all employee records where the manager NAME is like '%Raymond%'. (i.e. any of the four managers name is like '%Raymond%'.

How do I construct the select query? I tried this, but it does not work if there are more than 1 manager named 'Raymond'

DECLARE @Name varchar(50)
SET @Name = '%Raymond%'

DECLARE @EmployeeNumber nvarchar(50)
Select
@EmployeeNumber = EmployeeID
from
Employee
where
[Name] like @Name

SELECT
'HumanResources.Employee' as TableName,
E.[Name] as EmployeeName ,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID),'') as Manager1,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID2),'') as Manager2,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID3),'') as AppraisingManager,
isnull((Select [Name] from Employee E2 where E2.EmployeeID = E.ManagerID4),'') as ModeratingManager,
E.CurrentFlag as Active
FROM
HumanResources.Employee E

WHERE
(E.[ManagerID] = @EmployeeNumber)
or (E.[ManagerID2] = @EmployeeNumber)
or (E.[AppraisingManagerID] = @EmployeeNumber)
or (E.[ModeratingManagerID] = @EmployeeNumber))

Any help is very much appreciated.

View 5 Replies View Related

Storing 2 Decimal Points

May 20, 2008

I have a column in a table with a data type of float.

When I update it to store 7.50, it changes it to 7.5

Is there any way to force it to store 2 decimal points?

View 1 Replies View Related

Distance Between Two Points Lat/long

Jan 12, 2008

I have a user defined function, I want to determine the distance between the 2 points. I have it working but i'm having a problem getting to print.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++




Code Snippetcreate function dbo.Distance( @lat1 float , @long1 float , @lat2 float , @long2 float)
returns float

as

begin

declare @DegToRad as float
declare @Ans as float
declare @Miles as float

set @DegToRad = 57.29577951
set @Ans = 0
set @Miles = 0

if @lat1 is null or @lat1 = 0 or @long1 is null or @long1 = 0 or @lat2 is
null or @lat2 = 0 or @long2 is null or @long2 = 0

begin

return ( @Miles )

end

set @Ans = SIN(@lat1 / @DegToRad) * SIN(@lat2 / @DegToRad) + COS(@lat1 / @DegToRad ) * COS( @lat2 / @DegToRad ) * COS(ABS(@long2 - @long1 )/@DegToRad)

set @Miles = 3959 * ATAN(SQRT(1 - SQUARE(@Ans)) / @Ans)

set @Miles = CEILING(@Miles)

return ( @Miles )

end

DECLARE @RC float
EXEC Distance '39.943762', '-78.122265', '32.334709', '-96.633546'
PRINT @RC /* in miles */

View 3 Replies View Related

SQL Question - Order By Points/votes

Sep 9, 2006

Hi,I'm making a rating system that save the results in the database.I have 1 table with 3 columns:1) name2) points3) numberofvotesnow I want to select the 5 names with the best results. In other words the 5 best results when you do (points/numberofvotes)how can I say this in SQL? I hope someone can help me! thnx!

View 2 Replies View Related

Transaction Logs And Check Points

Aug 14, 2001

Previously I have posted about my problem with transaction logs. Threw my research I have found the truncate log at check point. I have also been lead to think that a check point could be a full back up. I have set this option to true and then performed a full back up. Afterward I have shrank the database to find the transaction log to still be over 43 gigs. Where have I gone astray?

Regards

SeTi_Ni

View 1 Replies View Related

T-SQL Debugger Not Stopping At Break Points

Jul 24, 2004

Hi all,
I'm trying to debug storedprocedures in query analyzer from workstation, login with server adminuser.Debugger is not stoping at break points.
any help regarding this will be greatly appreciated.
thanks.

View 2 Replies View Related

How Do I Clear Out Available Restore Points For MSSQL Db's?

Aug 14, 2006

I was messing around with backup strategies today at work while contemplating my other db issues.

In doing so, I've made a list of backups that don't truly exist anymore (I deleted the 'backup device' (bleh.bak).

Here's an image, stolen from technet's articles.

http://www.microsoft.com/library/media/1033/technet/images/prodtechnol/sql/2000/maintain/ppc1106_big.gif

See that list of restore points? Mine is full of restore points that have absolutely no meaning in them for a DB I made to test out (testDB).

Is there a way to clean those out?

View 1 Replies View Related

Identify Change Points In A Column

Apr 18, 2008

DECLARE @EffLevels TABLE (ChangePoint int, Value Int)

INSERT@EffLevels
SELECT'1000', '767' UNION ALL--Changed
SELECT'1000', '675' UNION ALL
SELECT'1001', '600' UNION ALL--Changed
SELECT'1001', '545' UNION ALL
SELECT'1001', '765' UNION ALL
SELECT'1000', '673' UNION ALL--Changed
SELECT'1002', '343' UNION ALL--Changed
SELECT'1002', '413' UNION ALL
SELECT'1002', '334' UNION ALL
SELECT'1001', '823'--Changed

-- My Result should be
-- ChangePointPrevChangePointValue
-- 1000Null767
-- 1001 1000 675
-- 1000 1001 765
-- 1002 1000 343
-- 1001 1002 823

Any suggestion ?

View 9 Replies View Related

Decimal Points In Money Datatype

Oct 30, 2007

Hi,

The default number of decimal points for 'money' data type is 4. Can I change it as 6?

Eg 120.123456

Thanks!

View 7 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved