Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Looking for best index
Message
De
04/03/2016 02:59:10
 
 
À
03/03/2016 19:12:57
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Autre
Versions des environnements
SQL Server:
SQL Server 2014
OS:
Windows 8.1
Network:
Windows 2008 Server
Divers
Thread ID:
01632184
Message ID:
01632517
Vues:
41
>>size db ?
>>size ram ?
>
>The database would be around 200 GB.
>
>The ram is 38 GB.

To date, my experience with SQL Server,
tells me that if the relationship SIZERAM / SIZEDB is very small 1
it is common to have performance degradation.
Certainly the size of RAM it must be larger than the size of the Client table including the indexes.

Another issues it is a bad optimization of @variables.

Do this test:
restart SQL service
exec this:
DECLARE @NoEntity Int
DECLARE @VehicleMake Varchar(30)
DECLARE @VehicleModel Varchar(30)

SET @NoEntity=19
SET @VehicleMake='VOLKSWAGEN%'
SET @VehicleModel='"CABRIOLET*"'

SELECT Client.PrimaryKey
 FROM Client (NOLOCK)
 WHERE Client.NoEntity=@NoEntity AND Client.VehicleMake LIKE @VehicleMake AND Contains (Client.VehicleModel, @VehicleModel)

-- time 1 ?

SELECT Client.PrimaryKey
 FROM Client (NOLOCK)
 WHERE Client.NoEntity=19 AND Client.VehicleMake LIKE 'VOLKSWAGEN%' AND Contains (Client.VehicleModel, '"CABRIOLET*"')

-- time 2 ?
post time 1 and time 2.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform